Worksheet Functions [Archive] - Page 91

can I reference a sheet name in a cell as text?
Make stair columns
HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?
Data Validation
vlookup using two lookup values?
Lookup same word "value" across multiple cells
copying and pasting a formula
Problem with #VALUE/0! error
Vertical Lookup problem
Breaking up a string into separate columns
Searching for multiple results in one cell
Calculating slope, intercept, LOGEST with empty cells in data
Clearing #N/A's in one go?
Functions
Cross-referenced drop-down menu (nested drop-downs?)
sumProduct (gimme a 1 if this is true, gimme the value) what is th
Excel formula help needed
OPPOSITE FORMULA
Index Match function for multiple linked variables
Index Match function for multiple linked variables
how to use "IF" to do nothing if a cell is blank
This should be easy
shift right 5 columns
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS
drawing rect function graph in excel
formula question
Lookup type formula
Formula for growth chart?
Using hide in excel get "cannot shift objects off sheet"
F5 function for zeroes?
get a total based on criteria in two columns
Can somebody help me with this formula
How do I filter out duplicate values in Excel 2000?
OT? Microsoft Works Database Import?
Copying a total from another Sheet
halving contents of a cell
#N/A is not text, cannot use it in functions
collect data's from different excel files
IF statement
How do I compare the difference in two spreadsheets?
Formula Problem - interrupted by #VALUE! in other cells!?
hyperlinks in drop down menu
Rolling 3 mth Average
hyperlinks in drop down menu
how can I calculate VAT for selective data in the same column of a
Difficult Excel Problem
remove all ","
How do i compute the average value of 100 iterations?
formulahelp
Find a negative number in a range
VLOOKUP used only when IF condition is met
0 in linked cells when watched
Interrupting A Worksheet Calculation
Is there an "auto tab" option in excel?
Display text depending on values of 3 different cells?
Re: Using a Pivot Table Calculated Field to get a Unique Count
EXTRACT NUMBERS FROM TEXT STRING
entering date functions
getting the last cell value in a column
programming date functions
Displaying seconds in hh:mm:ss format
Average
Referencing a different Workbook
Finding values based on color
counting the number of times something is bought during a month
Concatentate Join Identifier
Dealing with numbers that begin with a 0
adding three consecutive columns
VB Protection problem
What is the "--" used for - or how do I ask excel for help
Getting #N/A from Vlookup when matching value exist in the lookup data range.
Count on multiple values with duplicate rows
How do I select form a drop down box by typing the first part?
deleting macros that are not really in my workbook?
Adding Worksheet To Formula
How do I create numbers for a Chinese Auction?
Now()
Formula questions
How can I get this to function please.
Re: Hour and minute
select based on word CDS being in description field
Pivot Table Subtotals - Difference
Calculate duration in Excel 2000
Do I Need to Use an IF Statement?
Refering cells between worksheets
format cells
Tab Key
Remove html markup
Empty Lines
Delete Cell Function
Creating a Summary Worksheet
Finding the Max of a related Value Lookup
Column labels
How do I count in a range of dates?
importing data
How to save the current worksheet as JPEG, TIFF or DICOM?
How to create a menue bar of numbers in a cell?
indirect?
how many if statements can i use in a single cell ?
Is it possable?
-ve no with -1; positive with sign+ and 0 no sign? Tks.
vb code - Automatic transfer of data from one sheet to another
How to create a prefix containing text and zero?
Problem with TRUNC
Excel formula
SUM Days (to 30), Months (to 12) and Years
Too few arguments
populating empty cell with value from above
Number Formatting Question
Excel - how about allowing colored worksheet tabs for organizing
Dates - Months & Years
color fill cells based on IF function or formula
Regular Time and Over Time
Zero replaces blank field when paste special is used
Return of blank cell if lookup fails
Vlookup in large named range
I Have two files that i need to compare?
Time and Business Hours
Indexing/Matching True/False results
Can you make all sheets scroll when scrolling one sheet
PMT function
Last Number to Average
Filter one column for all "Pending"
Can a conditional formatting result affect another cell or cells
Re: Calculated fields-Pivot tables
How do I set up a conditional cell from a drop down list in Excel
Calculate Hours and overtime by week
Nested IF with OR Function
How to return the text data of the first col after getting the max value from the 2nd col
Have 2 items in dropdown, want warning if one selected
Nested --- Subtotal IF function
Formula/Array question with dates
Ignoring Time in a Date Time Calculation
What excel function to use?
Multiple Validations in for 1 cell
GETPIVOTDATA question regarding adding "rows"
count and lookup
How do I point to another cell
Can criteria in countif statement be a color?
hyperlink to another worksheet
I need to Sum the value D2:G1000
Auto fill multiple cells depending on single cell value
In Excel: select the last 20 rows of data in a column
I would like the worksheet auto name itself with a formula
Mileage Calculation
matching data from column b
Vlookup multiple worksheets
Printing Certain Columns
Match Last Occurrence of Numeric Value and Count BACK to Previous
if statements
DROP DOWN LISTS
formula looking up multiple information.
Variable Links to tabsheets
match values in two different columns
How to find square roots on paper
Two dimensional lookup
Rounding
Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats
How to tackle Division by zero for DAVERAGE function
returning a cell's value and a corresponding value
Active cell counting in particular print page (one sheet having different print area)
how to fetch a row and post the row into another sheelt
Part of text as criteria
Help with SUMPRODUCT
How do I do an amortization schedule knowing the princ, int rate,.
Selecting a range of values for another function
SumProduct Solution?
CONDITIONAL FORMAT
aLPHAnUMERIC validation
Help!
Help with formula
Find max date
VLOOKUP Problem
how can I fix a missing formula bar in Excel?
Is this possible please someone help me ??
Click button to automatically add row
Excel - need a function to compare lists
Time code cell format
Re: Calculating percentages in pivot tables on subtotals
complex amortization
Matrix Dimension
Move merged cells with conditional formatting?
Count cell
How to summarize the first 4 numbers greater than 0 from a list.
How easy is it to loop in VBA based on cell contents?
How do I extract data from graph (i.e. interpolaton)
how to create the formula "cumsum" in excel
Why is my printer printing white fonts as black?
Error in "IF" formula
best formula to use
="Printed " & today()
linked worksheet formulas
Find last non-blank row with a worksheet function
Nested Formula
convert numercials into words
how to change absolute path to relative path
Problems with setting up a billing budjet
Validation List
calculate ranges
help needed in IF function
Indirect Formula
Offset delivers value error with Named range
can I reference a cell as someting like: cell(1, 1) ?
How do I convert a text string into a date?
Colouring a row depending on data entered in a column
#DIV/0! in the array function
Counting the number of values in a list between two specified valu
unprotect sheets
Excel cell show sum upto 500 Exceede delet without if else conditi
Need Help with complex formula
Conditional Formatting
Formula needed
Referencing cells on other pages
create a goto button in excel
I need to "cross-foot" from worksheet to another
Counting Data in a Column
Month to date sales - reset in new month???
help needed in VLOOKUP function
Please help me with a formula
Spreadsheets are cut off when you paste and link?
Recording Macro
charting your data automatically
excel.worksheetfunctions
Finding a value associated with a range
Editing a simple macro
Excel 2002; copy formulas to one workbook to another diff data
Problems with HYPERLINK in Excel 2002 and 2003
How to create a drop down menu for objects
In Excel, How do i add Words together.
Consolidate multiple workbooks
excel divide by zero error
how do i combine IF and OR function
limited lines in check register
from disc to cd why does it always become read only
Date Last Modified Function
how many rows did I selected
How can I update all workbooks in one go
Automatic calculation as sefault
How many rows have I selected ?
One worksheet to calulate different items simultaneously
Compare two cells from reference cells
date that updates itself daily, plus another formula please??
Excel should have a formula for amortization.
excel %
commissions by range
calculating commissions for a range of values
formatting
Using data from coloured cells in a chart
formatting won't apply to my cell with a formula
meaning of this function