Worksheet Functions [Archive] - Page 51

VLOOKUP
Applying a currency rate that doesn't change when source updated
Summary of values from a date range
Importing from other application
coloring overy other line without doing so line by line
Backwards lookup
Excel Map function
Averages: Exclude Rows with 0 Values
count if
Time Cards
Rounding to nearest integer
Cell References and External Data
How to keep linked cells blank until information is entered?
Need to avoid a circular reference...
Merge & Center
I have user defined functions in sprdsheet. I want to put sprdsh.
conditional forming causing linking errors
function values do not refresh
Enter an Excel cell reference as part of a custom header/footer
Recovering excel file
easy question
Looking for formula index/match-type that returns an array
excel to outlook
vlookup
Page margin units
If Statements
Merged cells
VB Code to do this....
Match Last Occurrence of two numbers and Count to Previous Occurence
How do I convert $500 to Five Hundred Dollars?
Excel
Excel
REMOVE SPECIAL CHARACTERS FROM TEXT CELLS
excel formula
Points behind next rank in a fantasy league
not able to convert text, or graphic number to regular number in e
How do I pause a macro to select specific cells
How do I convert 02/05/05 to 02, please?
formula help
Grand total same cell in all worksheets
formula help
Multi-If function
Boolean masks
how do I repeat a drop down box
How do I open a file downloading in MS Excel
multifuntion formula
Opening an excel spreadsheet
find a cells from a range of cell
Printing 2-up
ACN to CAN
EXCEL Question???
why does my cells turn blue like I'm formatting when I try to ent.
2 cells value to 1 cell
IF functions
I cannot rename my excel sheet?
apply cell names to formulas in multiple worksheets
How can I generate number based on two measurements?
Effective Annual Interest Rate
CSV FILE TOO LONG FOR EXCEL
How to make background grid lines disappear when viewing
Excel/Access 2002 sum function
Mouse right button not working
Two dimensional sum by week
Two dimensional sum by week
VLOOKUP Function
Changing display of decimal value based on the value in the cell
Hard page break that won't allow me to scroll past? would love to find out ;)
Sorting names in a range
VLOOKUP
LONG VLOOKUP
Microsoft Excel --> Microsoft Works Spreadsheet
How do you populate the X variables in Regression analysis for mo.
Right mouse button
How to convert columns of data to one column of text
how do I write a formula that will figure weekly overtime?
Formula for finding the differance between two times
if a cell contains certain text, cut and paste to another sheet
IF Statement question
getpivotdata refresh problems
Count numbers of entries
How do I combine multiple whooksheets with identical columns
how do I sum inserted cells in EXCEL?
Improper fraction format?
How do I export information from excel to word, ie database of na.
How do I identify the 7th digit in a 13 digit number, then establi
SUMIF Returns a #VALUE error when external source is closed
HELP...PLEASE...W/ IF/THEN/COPYTO STATEMENT - THANKS!
HELP WITH AUTO EXPORT FROM OUTLOOK TO EXCEL
Need formula for budgeting payroll taxes.
How do i count number of weekdays between two dates?
how can I add cells in hours and minutes, eg 1.15 +1.45 to equal .
How do I download install Excell 2000 Analysis Tool Pak?
Automatically Insert DATE, so that DATE will NOT change
Modifying an Array Formula
=RIGHT (function)
difference between two dates in years, months and days.
Global Setting For All Workbooks - Filename In Footer
cant add a worksheet
Get current cell with VBA function
Merged Cell will initally show text from 1st worksheet but then wo
CHAR(10)
I want to return a value based on the status of a check box. If .
Syntax for inferred cell references
Warning message base on date
can't insert more rows even though not at max rows
nested sumif or sumif with two criteria
sorting problems
create links for formulas
Vlookup Bmp
HELP with Formulas
Decimal Time
sumif vs sumproduct
IF and ISERROR Functions
How do I get rid of duplicate text?
subtotaling large data set
bringing data from one workbook to another using a date stamp func
How to countif involving another column?
How many values appear more than once in a range?
Finding dates within a date range
YTD Budget Totals
Automate Pivot Table Drill down
How to convert columns of data to one column of text
need help with a formula in excel
How do I setup a depreciation template for all types of assets?
How do I find the contents of a cell using the "ADDRESS" function.
For Ron Bruin Please
zip code entry
zip code entry
excel: How do I setup a function to put any numbers over 80 into .
"IF"
convert character to value at relative cell
Max and Min date from listing by account no.
function IF / how to input pictures into this functions /
can excel draw a shape based on values entered in cells
Array Function with VLOOKUP
access my data from my master worksheet while calculation is don.
Separating text
Autocalculate
Combine VLOOKUP, IF, AND in one formula
auto dating after entering the first date
Function IF / test / Picture result
How do I remove a blanck space from the beginning of a formula?
Converting imported numbers to decimals (rather than /100)
increase conditional formatting in Excel
Help comparing data and returning information...
Bring back the old help format!
excel help
"IF" formula question
Repost: Vlookup Bmp
Formatting combined Cells
Sumproduct with Wildcard *
Re: How to determine which rows contain slected cells in a multipl
Linking data that contains specific row criteria
Month/ year function.
SUMING VARIOUS LINE ITEMS FROM MULTILPLE WORKBOOKS
combining data from multiple sheets
Getpivotdata - referncing a data_field resulting in "REF!
Paste data from another worksheet
Is the data validation criteria limited to a few number of items .
Re: Networkdays
Bringing partial data from one cell into another
Networkdays function
Calculating differences between dates
Finding Specific Text in a Text String
Vlookup of an if statement return
How can I assign a number value to a letter grade in Excel?
Difficult matrix query
problem when saving CSV file
Counting days
How do I add an area code to a list of phone numbers in Excel?
EXCEL -- want to do have ''averageif'' - like sumif function - H.
Sum Formula Help Please
how do I rank negative and positive numbers?
RE: How do I sum and add * on each side based on value in excel?
How do I search for a string across multiple worksheets in Excel?
Re: Can I create an order summary report in Excel?
Re: appending data to individual cell throug function
Matrix Query Part II - lookup value
How do I import from Quickbooks and create a link.
import external data from changing file name
sumif involving another column
How To Use Cells Without Values in a Formula
how do i set up a "balance over 30 days" field in an invoice?
Data Validation
I want 20 rows in excel to take up full A4 page
Automatic Number Creation Problem?
How to create a formula for this function.
In Excell sheet i want to insert more than 65,536 rows how i can .
HELP - need to returns the current number of past month this year and ...
IF Functions
Why won't it Excel fill in weekly dates now, changes them to daily
Binary Numbers longer than 10 characters
Function question
how do I insert a geographical map
time format
Why does it say "Filter mode" instead of "X of Y records"?
'add-to-basket' function
INDIRECT.EXT question
Multiple Condition Sumif Formula
Old Lotus Files
Auto Update upon shifting, inserting or deleting
Date functuion.
$20,000 due. Pays diff $ every x. Int calc per annum. Need excel .
color cells with text
how do I type in a number and have it automaticly add to the exs.
rounding time question
Excel: Additional Conditional Formatting
Compounded formula using SUM & AVERAGE
PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)...
Mode Function with Criteria
How can I change an Excel spreadsheet that has UPPER case to PRO.
mag-text in merged cells-automatic row heigh
Count Check Boxes
Effective yield rate - non level premium flow
Macro Help
Reversing First & Last Name
IF Function - If the reference cell data is presently unknown
Lookup function with drill down?
counting coloured cells
Emailing a workbook with links
concatenating numbers
Summarize Data Set
excel 2002
Excel Formula WEEKNUM only works on weekdays 1 and 2, why?
SUMPRODUCT using months
Hyperlink ONE word in a cell ???
Counting days
How to link a document to a workbook with a hyperlink in excel
links
Need formula for: if A6=100 thru 125, then "A", etc thru "S"
Combining two formulas
VLOOKUP: type or paste values
Help with code please
Put a Worksheet in a workseet?
How to lookup multiple values and summing them up in one cell
Absolute address in Workbook linking
count check boxes
excel and access
Problem with updating values with INDIRECT.EXT
Using ABS() in a range of cells
Why are the cells of my workbook not refreshing?
Bring Back Qualified Sum from another WB
Please Help
Column WE
IF Function in incremental charges
Separate Spreadsheets
Help? start macro automatic in excel
navigate in Excel worksheet without scrolling
Need help with Excel Lookup