Worksheet Functions [Archive] - Page 20

Re: Command Button formula determiner
How to Calculate APR in excel
Count incidences of part numbers
How would I....
Meaningful averages
Protect my Formulas from idiots
easily linking cells from various worksheets
Matching and highlight cell with colours
Re: Date formulas (date + no of days to return date mon-dri only)
Working w/ Date and Time in SUMIF
Auto Fill Series of Dates & Times
Loan calculations
Re: Auto Fill Series of Dates & Times
Re: Lookup and highlight matching cell with colours
Second of Two Conditional Formats Not Functioning??
A sorting question
Funtion Help
To Fran Kabel
Changing text to a date
Can't delete a button
Last Reference Name function
Worksheet question
ROUND
Date formula
Newbie Question on Extra Space After Numeric Values
Dates Appear Different on Screen
Sumif to Countif ? Please
Re: Find Month to Date data - from weekly data
College Tuition spreadsheet
protecting sheets
Help with Lookup / Match functions
Excel XP Nested If Function Problem
Value
Per Diem Caculation
Making Macros available to other users?
set Excel to not print certain rows
"BLINK"
Nested IF function
Lookup in Excel
Averaging
date format appearing improper
Import data from mysql
total random cells
Convert phone directory to an excel spreadsheet
Dynamic formula to sum across rows
Sorting
XIRR
finding related cells
COUNTIF On Multiple Lists Causing Problems
Tab Name
VLOOKUP
Keyboard function (switching between formula and value)
Cell Format
Creating formula to calculate future dates...
Calculating commisions to be paid
IF function will not work? Can you see why??
Re: Finding Top Ten repeated entries in list
Making Cells Absolute
Delete Print Areas
Convert decimal number into hours and minutes
Resolve cell references in worksheet function arguments
Summarizing Data
count multiple conditions
Format Report Option missing from 2003 version -pivot table
Shifting Cells
Different behavior on other systems
Re: Concatenation problem
Very Hard formula
Using ApplyNames across ALL worksheets in a workbook
Lookup values with criteria
I have a negative number when finding the difference between 2 dates
Hours and week days
Re: Hours and week days
Cell Format
Refresh Advanced Auto Filter
array help
Microsoft Excel - "Edit Cell Comment" abnormality
Excel 2002 Page Setup created in Excel 98
Re: Microsoft Excel - "Edit Cell Comment" abnormality
formula not calculating correctly
Re: Substitute Function: Trying to incorporate variables.
SQL.Request in Excel 2003
if function
will not paste multiple copies
Make a negative # =0
continue a number if less then previous
Re: count, sumif, sumproduct
Concatenate different text formats
COUNTIF
CUMIPMT with balloon payment
SUMPRODUCT Issue
Protection Issues
Re: IS THERE A FORMULA FOR THIS PROBLEM ?
Windows task
Rounding issues
Re: Match and offset
Can i make some worksheets auto and others manual calculation
Excel slow to scroll
Mouse Pointer Stuck
Re: Nested IF statement HELP
vis basic & creating an invoice
How to round currency values to a number divisible by another number?
Ken Wright :toggle autocalc, workbook vs. worksheet
Timesheets
Hours worked computation???
Delete empty rows
Delete Empty Rows --still not working
Make CountIF work like SUMIF
Re: Convert a sum formula to a count formula
Comparing ARRAY elements with RANGE data and created a 2nd array
Converting numbers into words
VLookup issue
How can I Filter a sheet to exclude some datas of another sheet ?
SUMPRODUCT
How to generate next number?
Random numbers
Formula to count age by month
T function
Retrieving Data from Multiple Sheets
Weighted Average
Re: Calculating Business Hours
functions/events based on user selections
Display # from another cell if another cell's # is within range
Find item in list by referencing two conditions
multiple column match
inserting specific page number into footer
Hours worked = pay
Tick Marks
Vlookup across multiple sheets
Re: No Rounding - need full decimal value
Re: Print comment notations
Computing Cmpd Return on Irregular Investments
Printing a list of Worksheet Tabs
Help - Linking sheets and data from Sheet 1 to blank worksheet
required rate of return
Re: Solver Delay: Additional notes.
formula
Macros in XP
variables in cell references in formulas
SumIf Formula help to figure CA Overtime Laws
Excel formula to convert number to words
Zadeva: Using and IF formula for a cell value between two amounts
Tally no. of "VName" in column C and "Owner" in column M
Macro needed data query
Month Serial number to Month name
UDF recalc question
AUTO ADDITION
Re: Military time computation/Overtime??
Got me stumped
switching 2 Y axis graphs
CountIf and And
Compare Worksheets and Copy/Paste Data
Re: Combo Box Control - CONTROL tab missing from FORMAT CONTROL dialogue
links
changing numeric value to text (in words)
Re: Data reference in Formula
Formula/function shortcut?
Re: is there a formula that can count a range of cells with text?
WEEKNUM function
Setting Print Titles on multiple worksheets
conditional format to indicate duplicate entry
Looking up multiple criteria to find missing data
Data transfer2
Combined conditions
DateFunction
Is anyone bright enough to help?
DateDif
Removal of "dot" following last digit
Importing unicode text file into Excel 2002
"pick from list"
LOOKUP
Nesting multiple "IF" functions
Re: Excel problem - Reference another workbook using last week date as name
lookop or index?
Cannot change cell color?
Hex to Dec conversion formula for Excel...
Using military time
transferring data between sheets
total days in month minus all sundays
VLOOKUP
Putting a COUNTA function in an Array Formula
Date formula?
Re: formula to display only part of acct #
Data Validation - Prevent Blank Cells
finding the column number where data is located
custom format
SMALL Function
Out Of Memory ' HELP
IF function
Macro question Excel 2000
Lookup Function
Free listing in China trading directory.
Re: Entering Credit Card Numbers
MS Word
Ever encountered #DIV/0 problems with COUNTIF
Need Formula Help
incorrect result of nested functions
inputting feet and inches
Pivot Table with Duplicate Field Names
Simple Excel Question
password on a worksheet
copy paste problem in excel 2002
time and hours?
Floating decimal
Deleting Empty Rows
Re: Deleting Empty Rows
Re: HLookup to link data across several worksheets
Regional Seeting Property
Using a Macro copy paste
This years birthday date
Open Add-In Type File in Microsoft Excel
Pointless rant about order of terms in functions
Filtering Duplicates
i need a formula
Lookup words
inserting a space in Concatenation
decimals
COUNT
Headers
Hyperlinking a specific worksheet ina workbook
Insert worksheet name
Sum() Formula won't pick up text
Re: Countif trouble
Re: Offset formula
Show the last 3 lines of a table
Calculations based on cell selection
Pasting to disconnected ranges
Using COUNTIF function on a filtered result
Pivot Table vs. Subtotals
Copy every nth cell across columns
Modify "Remove Dots" function
Formula to autonumber cells
Updating cells referenced to worksheets in same workbook
Summing Filtered Rows
Comparing 2 spreadsheets
Linking Workbooks
Right click menu dissappeared
If Formula
Vlookup
How do I continue a sales invoice such as a page 2 or 3 etc? (using the invoice template)
Continuous day countdown excluding weekends and public holidays (urgent)
Re: adding values from another worksheet by matching criteria
flexi date
Re: calculation decimal limit
Macro to call different sheets...
If() and then putting formual in the cell
insert the date automatically, and insert a number automatically
Creating graph of stacked %
Problems with MIN
Lookup