- hide a worksheet so that a macro can still find it
- Use Cell Content to Build Link
- Adding excluding zero
- Help Please - Dates in Excel
- Mode Function with 2 Criteria
- Find and delete part of formula for multiple formulas?
- Auto-update with multi-users
- help with simple formula
- Merging 2 different pivot tables
- Starting a macro with the IF function
- RE: help with simple formula
- Calculating non-financial rates
- Restricting Multi-user access
- Absolute References in cell formula
- Formula for Continuous Services Dates
- Can specific cells on a worksheet be hidden & password protected?
- sorting data by date
- Problem
- How do I do multi VLOOKUP's based on certain criteria per cell?
- Sum Product Problem
- Difficulties with COUNTIF.
- Tab in a cell?
- extrapolate data from series
- how do i protect an Autofilter funtion on Excel 2000
- filter list of text for unique entries using formulea
- OFFSET using ADDRESS for the reference argument
- Help in getting external data needed please
- Getting Count field to recognise rows with negative values in Exc.
- Setup Accounts Receivable functions in Excel til we get new syst?
- date/time
- Cell value = tab name?
- triadic combinations of words
- how to change path name of html source folder ?
- Doing Sums on existing numbers
- How do i convert years to months (formula)
- How do I bin numbers by a date in an Excel sheet
- Recover earlier version of sheet?
- margin trouble in excel,bottom always default to .62
- How do I display more than one mode in a cell?
- improve formula offset and indirect
- Eliminate formatting dulication in multiple worksheets
- IF scenario for a range
- Variable ranges
- doubling a number X number of times
- Combining rows
- How to use complex no. functions that have cell references?
- Sorting Worksheet Tabs
- Variable VB to assign new sheet name
- Date Conversion
- If statement for text
- please ignore
- I can't get the forecast formula to work?
- Data Source Name Not Found
- finding char within a cell
- Number of Conditional Formats
- Finding char within a cell
- In Excel the total is off by a penny.
- sqlrequest in excel 2003
- Returning all values from a lookup - not just the first/last one
- sumif issues over multiple colums
- functions do not calculate
- how do I total hours and mins in excel
- vlookup using a constant value
- Formual help needed
- Pivot table Data refresh
- Formual help needed
- sumif formula returns incorrect value
- vlookup weird error
- Counting Functions
- Sumif help
- create autosum macro along with notation on the side
- I want to show all comments on cells in one cell in the worksheet
- Nested IF and MID functions
- Finding a Value and inserting a value in another cell
- Fraction in 16ths format reduced to LCD
- Macro needed
- Micosoft Query does not export result set to excel
- variable to refer to "this worksheet"?
- Look up Problem withion Excel
- IF Statement Problem
- i,
- Past date in column to change color
- Please Explain in Lamen's Terms
- dates
- Please Explain Formula
- How many IF's can you have in a nested IF function?
- NETWORKDAYS() not avaialbe after reopening
- Excel 2003 worksheet name function?
- Modifying sumif formulas.
- Could the "Criteria" in COUNTIF function be a cell reference?
- how do I calculate an input "c" to add certain cells?
- ttest function
- vlookup
- Using Excel's XML mapping/export with data organized in columns
- how to I refer to current workbook without using its name?
- Ttest
- how do I convert text in excel to 1st letter capital,only
- Making an ouput file
- How do I link multiple cells at the same time?
- check a checkbox in a formula
- making controls transparent
- Concatenate in Pocket Excel
- search in the entire sheet for different letter and cal.
- Auto Numbering Each Cell In A Column
- Creating a certain number of entries based on a number in a cell
- How Do I Hide A Row (if a condition is true) using a Macro ?
- con't paste merged cells
- pivot date sort/show
- Lookup values in multipul sheets and show value in another sheet
- Creating norms
- Help with what should be a simple formula
- SumProduct Question
- SEPERATE NUMBERS IN A CELL
- PLEASE HELP with the SPELLNUMBER function
- Cash Flow by Week
- array formulas
- Letter/Number Split
- Cumulative Sum
- SUMIF problem
- simple formula
- What is the formula for converting farenheit to celsius?
- Decimal Subtractraction
- My formula Is giving me a #NAME!
- Earliest Date to populate?
- formula help please
- subtotal - pivot table - or better function
- RE add cells together if value has a formula
- How to protect the cell's formula not be deleted
- Can I empty the cell who has formula in it
- Auto fill in cells
- Save as Dialog Box Mysterious " "
- Calculation in a Row
- Cant find it!
- Reformatting formula
- Protect Format OF Worksheet
- Define list of worksheets
- Setting character attributes in a text string
- drop down box calendar
- SUMIF function not working
- How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"??
- Creating a blank when links can't update
- Modify A SumProduct Formula
- forecast function
- pivot date sort/show
- what is the excel equivalent to lotus backsolve
- pivot zero values
- pivot field of fields
- multiple pivots updated with selection in one table
- Automatically changing stock tick quotes to decimal-price format.
- How can I use replace(alt+H) for mutiple items needing replace
- countif conditional
- Combining Text from multiple cells under multiple conditions
- Why are my cell being divided by 100?
- Execel Question
- how do you delete a name in the the open box
- Sorting, Merging, and Re-merging
- Workbook Links
- How to input Jan & have a series filled in for the rest of months
- How to convert numbers with apostrophe's (ex. 219'2) to decimals?
- Copy and Paste between 2 worksheets with VBA
- SUMIF function help
- A new sequence number in file everytime it is opened
- Accessing WorksheetFunction.XX from regular C# Forms application
- EXCEL HEX2DEC conversion error
- EXCEL:NUMBER TO GREEK WORDS
- SUMPRODUCT and search string
- How do I lookup a value in a array that is not in ascending order
- sorting two columns together
- nested IF maximum?
- copying cells based on criteria
- How to round up the result in a cell containing formula
- dealer evaluation
- Formula related Crash on Opening File
- COUNTIF FUNCTION
- HELP ME, PLEASE!!!
- HELP ME, PLEASE!!!
- how do i display numbers in lacs
- create a top 10 list of sales figures
- re-selection of Chart data range using keyboard
- Counting Unique text entries in a sheet with a condition
- Using Offset to name a range
- COUNTIF for 2 conditions
- IF Scenario
- display multiple lines of text within a merged cell automatically
- How do I convert a net $ to a gross $ in excel
- how do you copy the same cell reference on different worksheets
- how do I cut and paste into a protected worksheet?
- Number changed to Currency and ...
- Can I combine the text from multiple cells automatically
- how do I cut and paste into a protected worksheet?
- PLEASE help with IF function...
- need formula
- Need help looking up value based on criteria
- Rounding Time Calculations
- indirect cell reference using copies of worksheets in same workboo
- calculation error
- lookup within a cell
- Counting unique text/number cells from a range
- Selective deletion of rows containing certain text.
- How to add only certain rows in a spreadsheet
- Array formula not working
- Formula to spread number across
- Counting Unique Values
- ALL CAPS to regular text?
- Delete duplicates
- HLOOKUP
- change format for phone numbers automatically
- worksheet malfunction
- move spread sheet
- Excel date function
- Adding Borders
- IF Statements
- Can Excel do this?
- Set up global custom header and footer in Excel worksheets?
- Column Chart Question
- Pivot Tables- Total the Subtotals?
- Rounding Question
- How do I create a COUNTIF function with more than one criteria?
- line break in a cell
- Sales budget
- Add two IF statements together
- MAXIMUM VALUE
- MAX text
- Pulling larger numbers from group
- Can I create a formula in Excel that evaluates form information?
- OFFSET command and linked documents
- PATH SHOW UP - HOW DO I DO THAT
- How to transpose linked data and keep it linked?
- Conditional Sum and DATEVALUE function
- can a revision # be updated across multiple worksheets in the head
- Copy Address Bar Functionality
- RANK bug: same values get different ranks
- help with date and time
- Nested Functions
- using wildcards in vlookup
- countif help for multiple criterias
- RE: Ability to change the Excel comment indicator color
- Sorting data by date
- Nested Lookup !! ?
- percentiles?
- Can I randomize whole numbers in my excel sheet?
- Pivot Table Data Field Query
- Populate a combo Box
- IF/AND Statements
- how do I set up a machine service schedule
- What is mathematical equation for NORMDIST (x,mean,standard_dev,TR
- Macro to search for and display data in another worksheet
- Formula equivalent of CurrentRegion
- Picking data
- Querying data from Access
- How can I count strings within strings
- ListBox, error 424
- Lookup or similar
- add cells if the value of another cell =?
- Custom Auto Filter default setting should be contains
- cell character extension
- Macro Solution for Link Problem?
- find *
- Changing Worksheet Name in Link
- Macro avoiding circular reference
- Number to words literal
- Links in Excel
- formula to lookup table in another Worksheet please
- Excel - Find & Replace text in a string
- Excel formula
- how do I convert copied Text numbers into values in Excel?
- Neeeed Help!!
- indirect reference
- Macro for autofilter using variables declared in worksheet
- A counting formula that won't count multiple instances of same val
- Output of expired dates
- formula to round up?
- AUTO COUNT IN A CELL WITH EACH TIME USED/ OPENNED
- excel consolidating
- How do I conditionally delete rows based on cell contents?
- If/Then formula help
- Formula Please
- I cannot see my worksheet I think I restricted it somehow
- Lookup , match, not sure !?
- lookup question
- Excel Auto Shortcuts
- Pivot Table Grand Total - Calc Item
- Can wildcards be used in SUMPRODUCT conditions
- VLOOKUP question
- Number of semi-monthly periods between 2 dates
- Subtotals & Filters
- HLOOKUP improvement?
- automatic input of cell values
- DSum problems
- Exporting from Excel to a Fixed Length Flat File
- date calculation issues
- need to make a cell with numbers ascend when printed in multiple?
- IF Statement Question
- Lookup formula - treat no-registered cells as blank
- if blank cell, don't calculate
- Pivot Table not Updating
- Consolidation
- Update cells formula
- Extract Text--Hopefully Easy!
- CHANGE "C" TO 100 TO FIGURE EXTENDED COST
- How can I turn auto correct on or off for one column only?
- How do I use the Transpose Function
- Question when Copying an Existing Worksheet
- formula/function question
- Need help with creating a text file via excel
- Need formula to find and sum values in a different spreadsheet
- How I can built combo box step by step
- print different worksheet by pressing visible button on worksheet
- Lookup Formula - but have a formula if it can't find/match a value
- Text number to number value for calculating
- Conversion of Figure in Words
- Date Format Inside of a SUMIF Statement
- How do I make a blank cell with a date format blank?
- 6.00 to this 0600 please
- Replace "-" with "0"
- Counting within a filtered range
- SUMPRODUCT help needed
- substitute
- automating get external data (from web)
- How do I copy Page Setups from one Sheet to Another sheet?
- Change character while copy
- how can I activate a 'numbers' duplicating prompt (help)
- sumproduct in a range
- Entered text value equals a number I specify in another cell
- Can you paste values on multiple worksheets at one time?
- How do I make all pie charts identical in size
- keep totals from month to month?
- Sorting two columns of data
- SCurve function in Excel
- calculate no. of years between a date and today's date
- Venting
- Multiple criterion including wildcards to sum in a range
- +1, Alpha *and* Numeric
- From x date To x date you have earned x$ (dates are not the same)
- From x date To x date you have earned x$ (dates are not the same)
- Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1
- Re: Incremental comparison
- between dates
- Pictures in a worksheet
- Password protect a workshhet on the net?
- skus in columm a for each sale, qty. of skus sold, each sale in co
- correction of formula please............
- need help in correcting the formula
- Excel to automatically enter a date
- Sort
- Vlookup with to parameters
- Macro Help
- how do i subtract a negative number
- Looking up a value in a different file
- coloring every other row in a range
- SUMPRODUCT with Wildcard
- arrays and pivot table
- Losing data on copy and paste functions
- A Function for Counting Since Last Time
- How to copy paste from Excel and leave the pasted data editable?
- how do i automatically sort data in a pivot table
- Change sheet name on linked cell by dropdown box
- adding summed cells in a conditional sumif
- Combinations
- How do I create a Map with an Excel worksheet?
- A formula to show Next month
- multiple possible result in one cell...
- Lists
- Transpose Arrays with variable row counts
- Nesting functions in the functions dialog box
- How do I tab within a column using the tab key?
- macros security settings on Excel 97?
- Add new inventory list to existing list
- The formula to operate in shhet2 please.
- Count help
- "Delete sheet" not an available option on File menu.
- Formula to identify cell with different value in list
- How can I prevent email addresses from automatically hyperlinking.
- Vlookup that does not return #N/A
- Multiple Conditions in a cell
- Hide AutoShapes On Excel Worksheet
- "IF" function: Can a calculation be an answer? help plz
- Excel formula
- LookUp Type Question
- FV Function Problem
- How do you change the color of a hyperlink after you click on it?
- worksheet functions2
- Suming 2 cells if 1 = #N/A
- How can I add values to a closed excel file?
- How do i format a 5 to 6 digit number into the correct date?
- forms and functions
- How can I DISPLAY Filter Criteria
- question re: macros
- Setting dynamic range in a formula
- Grouping
- Lookup Table Dilemma
- Not Lookup
- Select top 5 in column A, sum values in B
- worksheet functions
- list comparison
- excel
- How do I create columns that expand and collapse in Excel?
- Concatenate and Mail Merge
- CopyCellContents
- Replaceable parameter in formula
- Can I place a formula/cell reference in the Header/footer Excel
- photos on excel webpage
- I need to do a sumif on data that [contains] a specific string.
- Get Column Letter from Column Number
- Can I protect a range of worksheets in a book with one action?
- Unique Dynamic Validated List
- Hyperlinks
- how can i calculate uk apr with excel
- Lookup Vector > Lookup Value
- Wildcards in Functions
- look up more than 1 field
- Populate a column by extracting unique values from another column?
- How to split the contents of a cell between two cells.
- if formula in cell
- vlookup function
- Formula to find cell with data on a row
- excel 2002
- Any Samples???
- best program to do purchasing analysis for multiple locations?
- Hyperlink changing row
- Copying Formulas
- assigning macros to buttons or autoshapes
- Need number of Saturdays and number of Sundays between 2 dates
- Printing Macro
- Background
- multiple items in database
- Reference multiple cells in if statement
- Copy drop down boxes and associate to cells dynamically in excel
- sumif on multiple pages?---not just one page
- pivot tables & queries
- How do I ignore cells in Excel?
- summation y years
- Is there an APR formula for excel?
- XNPV function
- can i get excel to choose every 10th entry in a spreadsheet
- From Target to Source
- NETWORKDAYS FORMULA
- Is there a function to change a number to text?
- vlookup & wildcards
- how are random numbers determined
- A Function for Counting Since Last Time
- How do I remove the 1st 4 characters of a field in Excel?
- rolling time period
- Conditional Filtering
- radians
- Why doesn't nesting subtotals work in 2003 version?
- I need Counting Help
- Show trial solution
- Compare 2 cells values with one IF statement
- Excel auto calculation formula question.
- cell links
- cell links
- Number Formatting
- center text in a formula result
- Need worksheet formula
- DSUM
- Paste values
- Cell errors
- Printing??
- Count # of times value "x" appear across multiple worksheets
- Taking data from 3 different cells and adding the components toget
- How do I turn off the automatic hyperlink function in Excel?
- Conditional formula
- Help with Formula Function
- function execution
- Selecting the top 4 largest value cells??
- Vlookup
- Number of Week Days _including_ Holidays
- Conditional list without blank rows
- Compare and display multiple rows
- Extract number in middle of cell
- I am looking for help on a formula
- Can a vlookup value be more than one cell?
- Conditional Formatting a Schedule
- rate function formula??
- Age band formula
- Wildcards in Functions
- MATCHING OF DATA
- Find duplicate numbers in large Excel Spreadsheet
- Find and Replace Formula Links
- Database Functions - question using formulas as criteria
- SUMIF
- Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?
- Assigning macro to a hyperlink
- complicated sumproduct.
- Auto average function
- Is lookup the key?
- Problem with opening an Excel - File
- How do I delete multiple cells with decimal, not whole, numbers?
- How do I put multiple references in the same cell?
- How to run code to change Excel comment font
- error message when editing a large spreadsheet
- write a function to determine if cells have names
- empty columns
- Extract Part of String
- how to count occurence of numbers separated by , in a single cell
- Count Unique Values
- Get the sum of figures in red or a colorin spreadsheet
- How to set up weekly time sheet with flexi time.
- Decimal to 24 hour clock please.
- Can't open files
- Date
- Function Help
- How do I use countif across non-adjacent cells?
- Merge Worksheets
- how do I add rows to a very large spreadsheet
- Challenging Duplicate Question...
- function execution
- Can you format a whole column of numbers to round?
- VLookup problem
- Correlation Question
- Reapeting Numbers From A Formula
- edit out ascii char 09
- currency # to full text equivilant
- How to resize Data Form dialog window?
- deleting 100's of pictures, keep data
- deleting 100's of pictures, keep data
- How to create excel templates
- Can't get a formula to work in each row of an Excel sheet.
- how can I use shading as criteria in a formula?
- Disjoint range for DSUM criteria
- Form with submit button
- Need Formula
- Can you make a cell blink?
- Ignoring letters behind numbers
- How do I convert every cell in a spreadsheet to round to millions
- trim
- Excell: count occurance of letters in a column
- referencing cols in functions - NPV
- IF a number then....
- How can I allow an outline to be collapsed on a protected sheet?
- I need an Excel formula
- insert field from Word into Excel
- Search string for alpha or numeric
- 3rd friday in month
- How do I make it change colour
- Linking Workbooks
- LINEST bug in Excel 2003
- Time in data validation?
- opening text files that have more rows than 65536
- How can I replace 2 of 5 characters within an cell in MS Excel?
- sumproduct by date
- How do I separate words in one cell into two cells?
- copy combobox - cell link to change automatically
- Display rows of data - vlookup?
- set checkbox to enter date when checked and NOT recalculate
- Alternate to Lookup?
- HOW TO SAVE FILE NAMES IN COLOUR OR DIFFERENT FONTS
- how do i change 20050614 within in a cell to a recognised date
- Display the last value of an array
- Display the last value of an array
- [Shift] + [Arrow] key usage with chart ranges
- Advanced Filtering
- Trying to count occurences if 2 conditions are met
- Count With Date Problem
- progressive select
- get characters from a string in excel
- Need to use IF formula with a Date cell
- Array Function Question
- rolling year in excel
- reccuring date on spread sheet
- If-Then Statements
- LOOKUP & RETURN CELL ADDRESS
- Count bold text values
- A good book on Excel XP functions
- duplicate formula
- How I use IF function
- Assign values to text within a cell
- Create formula for detecting duplicates
- Formula that recognizes duplicates
- Binomial Proportions: Two-Sample Test
- How can I print two sided documents in Excel?
- Help with function to sum values in a worksheet depending on account number
- show what % bottom # is of top # in excel
- if logical test true, then hlookup, if false then difference betwe
- Possible Lookup Table
- We're sorry - We're unable to service your request
- Function to search a row of data.
- Custom Date formula needed
- How can I sort SSNs in Terminal Digit Order using Excel?
- Function to del rows based on cell value
- Summing a range using INDIRECT & ADDRESS
- Using SUM function with #N/A in some cells
- Formula Help Combing two AND statements
- How do I calculate running pace?
- Need listing of links in a worksheet
- minutes between
- How do I use the MOD formula to do the same action to a column?
- Control for Worksheet static
- Formulas
- Fibonacci function/command in excel?...tia sal
- Fibonacci function/command in excel?...tia sal
- 3D Named Ranges
- How to sum lowest lanking numbers?
- using offset with array formulas
- making one workbook out of two
- Formula HELP!
- time sheet calc by time in and out
- Problem with Excel SUM function
- Array Formula
- yearly invoice
- Can you Link 3 cells into 1 in Excel 2003
- REMOTE CELL FUNCTION
- using SUBTOTAL() on rows that have been hidden
- minimize problem
- Count data in cells
- 3D Ranges
- Creating a macro to find and replace text
- save multiple page setups in Excel
- Stoping users pasting formulas into cells
- how do i get "DGET" to take the first data meeting the criteria?
- "if" formula to sum several cells...
- how to set up Bowls league 12 teams points and shot difference
- Average Array Formula
- Calculate the CAGR
- Cut links between worksheets in same workbook
- Lost password
- Split PN and Price
- Adding up Sums
- How to reference a cell in MS Excel that already has a SUM value?
- search through workbooks
- Autocalculate does not work
- sumif Q
- What worksheet function will formatlessly copy cell contents?
- How do I refer a Range to a Cell
- VLookup
- SUMPRODUCT
- Making a bar and a line graph together
- Time scheduling
- how do I remove empty spaces trailing a text string?
- Formula help!
- HOW DO I CONVERT ANGLES TO DECIMAL DEGREES
- Sumproduct with Date column
- SUNPRODUCT and COUNTIF
- Sort ignoring negatives and positives
- Sum of ranks
- Formula preceded by + sign
- Using sumproduct to count number by date
- how do i set up an expiry date in an Excel worksheet
- formula
- Adding By Color
- Assign a color to a cell
- I wish to have multiple column widths for a the same column.
- Drop down list with an if statement
- VlLOOKUP function with MATCH
- Statistically Confident
- Auto Calculating Time Sheet
- Columns creation
- VBA Conditional Formatting has mind of it's own!
- Frequently used file suddenly becomes 'not a valid file name'
- Insert comment in protected worksheet
- How do I set up a workbook so changing Sheet1 changes all sheets?
- Formatting a cell
- Macro Filldown
- Conditional Formatting
- MIN Function w/ variable address reference
- Unhiding worksheets
- Excel help
- vlook up and if formula
- Worksheet Name
- If statement using multiple conditions
- Search and replace
- Filtering ?
- chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005
- Recurring annual events using a specific date as a trigger date
- Formula checking multiple worksheets
- MAX formula with Associated DATE
- lookup more than one cell
- How do I subtract 1 hour from one cell and input it another?
- How do I do a conditional format for numbers
- how to subtract time cards in minutes in excel
- Cannot save external links?
- How can I return a thank you note
- index random questions
- Calculating Profit and Loss in one column
- sort data in cells in a row
- is there a 'format painter' hotkey?
- I know what I need but dont know how to do it
- random number results
- Printing sheets.
- FIND
- If function that returns value in a cell.
- Problem with XIRR function returning #NUM!
- using wizard and conditional sum
- SORTING DATA
- Copy 1 Sheet to Another
- Formula checking multiple worksheets
- Returning with cell on right/left of a reference
- COUNTIF Q
- How do I specify cells to return a result in a quadratic?
- VB script help..please !!
- AUTOTEXT Feature of Word in Excel
- Return Consecutive Values
- Lookup Question
- How does the Database Function work in Excel
- check if reference exists, then return its value or return 0
- If Statements - how to do is like '%value%'
- copying content of cell automatically to multiple cells
- excel
- excel
- Automatically enter today's date as a static entry
- How to print the column # where the max row value is located?
- How to do more then one vlookup?
- Is there a way to pick the cells to add using sum?
- IF Function
- Formula checking multiple worksheets
- Autofill/Reference Confusion
- Why do we start the formula with + or -
- Assign vaiable to a cell - gold
- SUMPRODUCT using and INDEX function doesn't total
- how to get the rounding function off
- helpfull links
- Can anyone show me how to set up Excel for feet and inches?
- Produtivity Formula
- CountIf first column range = "Word" and second column range <> 0
- Is is possible for a cell to reference it's "sheet name"?
- MS Dialog 5.0 sheets - Accessing data elements of objects
- nested function to add columns
- If Formula suggestion
- Excel should allow calendar based spreadsheet linking.
- Sort of format Question
- Counting Unique Cells When Spread Sheet is Filtered
- Last Value in Column
- Font size
- Vlookup through entire column
- jump to hyperlink, extract value at specific destination in file
- Excel Statistical Functions and Routines
- Delete columns or rows
- VLOOKUP works sometimes
- Calculating recurring date in following month, calculating # days in that period
- Formula checking multiple worksheets
- "Drop the lowest" in computing average
- find and replace links in Excel 2003
- Can I use cell contents as part of a formula?
- monitoring a changing range of cells
- How can I locate the second to last value in a range?
- move column headings from row to column
- "Sumif" and "DropDown" in palm
- Nested Countif
- How do I shade cells during selection?
- problem with SUMMEWENN
- alternate blank row
- Conditional Formatting with two Spreadsheets
- Pivot Table - Extracting specific data
- Pivot Table - Extracting specific data
- Decimal points not needed
- SUMPRODUCT vs CSE
- MARK EVERY FOURTH ROW
- Conditional formatting in relation to other cells
- Average of filtered data
- HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA)?
- Help Userforms / Excel SUMIF
- Please help with formula
- Pivot Tables
- Further Question about Transpose
- Search in 2 kolumns and 1 row
- conditional value required on basis of column a
- extracting text data in a cell
- column changed from alpha to numeric
- sequential numbering in non adjacent cells
- How do I create a numbering format in excel?
- Exclude data from summary totals when hidden
- vertical text
- Conditonal Format Formula
- Is there any way to get an AVERAGEIF & MEDIANIF function in Exce
- Data Manipulation FUNCTION
- Cell Height formula?
- Formula checking multiple worksheets
- 2 files, mass update comments between files
- Sorting data in a master sheet
- SUMIF With Multiple Categories
- Data Valadation -
- need function to sum top ranking items in list
- subrow names must appear in consolidating by category as tab name
- Syntax for 2 AND conditions within an OR function.
- Use formula to hide/delete cell?
- Advanced use of IF
- cells functioning odd
- How do I count how many times a code appears in a column?
- Name list
- SumIF
- Still need help
- macro used to change colors
- Counting capacity based on technician schedule
- I cannot get Excel to put negative amounts in brackets. Help !
- name list
- Options Button
- in excel I want to set up a drop down & link that to another cell
- Anagrams
- automatically filter out blanks in multiple columns
- SumIF Formula
- Is Datedif Outdated ?
- Time Value of Money
- Logical Function
- The ExcelTip forums update this forum
- How do I get a row to show up on every page
- Complex If Then formulas
- if coum 2 has vale then populate colum1
- Multi-layer excel spreadsheets
- stop automatically changing fomula ...
- look up same values in coumn1 and calculate values in 2nd column
- Formula on nth row
- Dependent lists
- Wildcards in other workbook cell refrence?
- Pocket Excel/Workday Function
- Excel % Variance Formula........
- Excel function problems
- Format Excel column to notify with a reminder
- Match/Lookup Statements
- Returning an answer in an if fuction between two values
- SUMIF??
- the cell currently being evaluated contains a constant
- comparing a value in a cell to see if it is higher than a number
- How to Calculate Time
- =B
- 16th digit changes?? Problem,16th digit changes to a zero....
- How do I move or copy more then one sheet at a time
- Unexpected result
- Can I add a Warning Meassage to a Macros Designed to Delete a Row
- Separating Numbers
- List
- Past Due - Due Dates
- calculate the value of a mortgage purchased at a discount
- Excel Statistical Functions and Routines
- "COUNTU" function in Excel to count unique entries in a range
- Automatically inserting rows
- List
- No showing of cellnumbers used in formular with colour
- working with IF statements
- Random Numbers
- Why do my dates change when I copy them between Excel worksheets?
- help!!
- Merge Worksheets
- How do I get rid of infinite numbers past the decimal place?
- vlookup
- Return range of values on an "IF" statement
- Hyperlinks change when Excel file is saved to a different director
- How do I use Office 2000 & Office 2003 on a network?
- Gridlines into excel spreadsheet after changing background color
- maximum of rolling totals - aka Rmax
- Reference to another worksheet
- using a slave worksheet
- Optimize simple macro
- Formula for # of sales days in a month?
- Excel to Access
- if statement in worksheet
- counting unique instances of text in a list
- DECIMAL PLACES IN FORMULAS
- Conditional Formatting Multiple cells based on 2 cells
- how to make cell address reference increment?
- Displaying only digits after the decimal point
- Opening Multiple Worksheets
- warning or message before saving spreadsheet
- Length of employment
- Date Formula
- help needed with text to column
- My copy function won't work - I get error "cannot empty clipboard
- Is there way to restart page numbering for each tab in worksheet
- Search and Get Function Help
- Averge time
- VLOOKUP WITH ALPHA NUMERIC
- how do u remove default setting?
- Re: can lookup a number to a 10x10 table?
- daverage problems
- Formula for next day based on clock
- Trying to email a spreadsheet
- Array formulas
- Troubles with the OFFSET function
- What is the use of {} before any formula?
- Re: Do I need a sumif or sum of a vlookup formula?
- Time Date Formula Problem
- How do I use 2 worksheets in 1 page
- emailing
- a search function
- calculate interest between two dates
- Filtering data to another sheet
- calculate predicted sales value
- Converting 100 cents to 1 dollar
- hidden names in active workbook
- the best prediction formula?URgent!
- subtracting hours and minutes
- How do I calculate the area under the curve using Excel?
- more conditional format conditions
- delete rows from multiple worksheets
- Sort data from 1 work sheet into another
- Web Services function call and data refreshing
- Help with an if statement
- How do i make a formula reference the last entry of a column
- need to program my lists to automatically alphabetize when new ent
- Linking from several cells of 1 spreadsheet to fewer of another?
- Sumif and autofill
- Determine the location of an external source of pivot table?
- How do I have a formula check if a value occurs within a range?
- Sumif Fucntion
- SUMIF using a multiple-column range
- Is there a function that allows me to list the names of excluded d
- COUNTIF or SUMPRODUCT counting multiple criteria
- Count if not 0 or return value of 0
- Lookup Value is Between Range 1 and Range 2
- Product development requirements tracking
- Empty cell control
- COUNTIF across all sheets of a workbook
- Macro - formula for end of last row
- Putting Sheet Names in a range and renaming it?
- ISERROR VLOOKUP
- RE: SUMIF using a multiple-column range
- Count the number of specific values in a cell
- Recogniziting Dates in an IF function?
- Opening Excel out of explorer or outlook attachment
- How do I put more than one criterion in a SUMIF function?
- Formulas in Excel
- making a number be text
- nesting functions
- RE: COUNTIF across all sheets of a workbook
- RE: Lookup Value is Between Range 1 and Range 2
- Only do Sum function if not "0", IF"0" then return "0"
- Column number of last column containing a number
- RE: Macro - formula for end of last row
- RE: COUNTIF or SUMPRODUCT counting multiple criteria
- Volume and pricing calculations
- HOw do I set up Standard Error in a spreadsheet?
- RE: nesting functions
- RE: Sumif Fucntion
- Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
- Access Rights & Reports
- Re: Autofill date based on date in another cell
- NETWORKDAYS gives #NAME even though Analysis Toolpak is installed
- normalizing data -- a twist
- add cell across all worksheets
- Ticks or Crosses
- preventing one part of a formula from iterating
- Hyperlinking
- How do I perform a contains function for a specific cell?
- sumif with 3 conditions
- renaming problem
- How select an item in a list box
- Even and Odd Numbers
- Fonts
- A way to refresh a certain cell everytime wroksheet changes
- transferring checkbook template to excel
- How to find method to cut steel coil by using excel.
- Combining specific ranges from multiple worksheets into one
- Insert excel data source into word doc using currency symbols
- Excel takes along time to calculate
- Can I count cells with specific format (e.g., yellow field?)
- excel compatibility
- I'm Lost, Need Help
- Sorting a sheet
- deleted w/sheet. How do I recover
- How to change a visible formula into a value? (Quickbooks download
- How do I count the number of alpha occurences in a range?
- adding a formula in a cell but when cell = 0 cell is blank
- Summing up time
- Why am I prompted for the workbook password for each worksheet?
- #N/A resutls in Vlookup when there is a match
- Excel Calculation
- Lookup worksheet agony
- Activate List of Email Hyperlinks
- Rank Question
- re:Any Ideas?
- Command
- combining numbers into combinations
- Extracting data without using database functions
- pair single column to multiple column
- Formulas e Funcções
- autonumbering
- Help with function to add percentage to cell based on checkbox.
- Excel should let me imbed documents and programs within its-self
- IF statement to check cell contents
- IF AND question corrected
- IF AND question
- random numbers from a data of numbers?
- ACTIVATE CELLS
- Help need with formula
- Login Logout Date Problem
- Bilingual workbook problem
- How do I sort a horizontal worksheet to create a vertical table
- validation combo boxes not working
- converting hours to days,hours,minutes
- same formula giving diff resutls
- Need a formula that would make life easier
- Dynamic Formula
- Constant growth
- Horny Teen Girls
- help with forumla needed... getting a yes/no answer to ??
- Stupid
- if statement module use please help
- How do I get a spreadsheet to print to actaul size of page?
- COUNTIF and Nested Functions?
- Decimal Question
- How to combine dat from 4 fields into one field
- How do create a formula to evalute a # to return 1 of 4 conditions
- concatenating "00"&"00"&"01" without losing the zero values
- update info on 2 sheets @ same time
- Problems with Sum Function
- Construct address as a reference not "text"
- find replace
- I am having trouble adding a row in Excel. What am i doing wrong?
- can I name an excel worksheet tab by linking to worksheet data?
- How do I apply the ROUNDUP formula to a range of calculated data