Worksheet Functions [Archive] - OfficeFrustration

Numbering rows for sorting
almost DSUM, but is there another database - criteria funcion?
Re: excel custom menu
Re: Time-of-day Average
MS.Excel vs Works Spreadsheet
Re: Calculating age from birth dates
Fields - Tabbing to the next
ISERR vs ISERROR
Select the Name of the Worksheet with InputBox
Bolding specific text in a formula
Comment boxes
select the worksheet
Re: How do I extract specific data out of a cell to another cell
Don't show Zeros
Re: Error #VALUE with TEXT(A1;"[HH]:mm") when changing regional settings
Re: Continual date countdown/reminder (Help!)
Trim function limitations
Excel "IF" function problem
sumif function
Notes
split worksheet
Combo Box & Linked Workbooks
Formula
E-Mail Hyperlinks in Excel
Excel column headings
Excel Conditional Formatting?
Compare 2 Worksheets & Find Matches
VLOOKUP problem
Pivot range update on mulitple tables
Comparing ranges
excel.exe program error
Extract a number from a cell of text
Re: Formula help, CELL Function help needed.
filtered list
Selecting from a list
Formatting Column with all Caps
Upper case to lower case
Networkdays calculations
pivot chart formatting?
Change Case
How to prevent function range auto-modification ?
Re: #N/A
IPMT and ISPMT
Possible to set Zoom on worksheets via Macro?
Calander
Vlookup or Offset question
attaching website links to excel file
Examples needed
Calculating Duration
Date List
concatenating cells
combining formulas
Rounding to nearest $
Sumif of cells less than a system date
Line spacing
Re: Countif using Criteria "<>""" ?
Balanced Scorecards
How to pass array variables in sub procedure
vlookup Sorry if it's confusing..
Comments that aren't Comments
Pivot table update
reversing lastname, firstname
emailing excel single sheet as attachment
deleting duplicate rows
Rounding up at 4
vlookup does not always work
Printing group symbols on report
How to multiply a text function by a dollar ammount
Merge 2 Worksheets like Word Mail Merge???
Index & Match
generating random numbers
import data from one worksheet to another
formulas
Visual Basics code
Creating new Option buttons
Running Total of Column
changing a button color
angled column headers
his own PR thrust
Re: Hyperlink Removal
formulas
histograms with normal distributions
Negative Numbers
Splitting cells / diagonally displaying cell data
remove link
Solve for X
Re: Table Formula
Specs for Random Number Generator
formula
Excel 2002 does not recalculate existing formulas
help with SumIF
If value is greater than, then....
Empty Cells, COUNTBLANK, and ISBLANK
Excel formulas
calculating with displayed values
How to Copy/Paste Only the Subtotal Rows in Excel?
Subtotaling in Excel Using Different Types of Calculations
Need help: I want to display the last save date and saved by in the footer
Impossible Matrix
Calculating Time
crore formatting
Columns now numbers?????
Re: cell to change colour at given date - how to
Personal.xls
macro question
worksheet protection/macro
formula
IF cell contents = ?????
Lookup question
Looks like kind of lookup but...
Pivot table - formatting
Excel Spreadsheet
Pop up function ???
Newbee show cell address
Totals in Days, Hrs and Minutes
Entering numbers
Sorting by cell or text format
spreadsheet question
match formula
Excel text converted to Number or other
Choice and effect
lotus 2.4 macro
Problem with Excel File after Upgrading to Office 2000
Worksheet updates
histogram
Macro to add cell value to refering cells formula
Compare adjacent numbers Within Cells
Excel 2000 255 character limit
"If" or "sumif"
global changes to hyperlinks?
Change in time where text is involved
View problems
date f(x)
automatically add a numerical unit on a daily basis begining with a date specifi
Bullet Points
cell references
average f(x)
Formulas not automatic
Formatting (General to Number)
Fonts of Drop Down Forms
Custom Template Worksheet Location
Exposant
Order form
getpivotdata
Column names and deletions
Vlookup or Match/Index to return value 2 rows down
Average function
average function
"Sumif"or "if" ...followup question
Sharing Workbooks
lookup for double column
LOOKUP function
watermark
sum minus the smalles cell
drop down
calculating number of days between two dates
Solving for Coefficients of a polynomial
Pivot Table Using Multiple sources
ROUND function or custom format
lookup formulas
LOOKUP Formula
Pooled regression and dummy variables
trendline equations are incorrect
Date Function: How to determine number of Saturdays in a date range
Macro
all today's work gone :(
AutoFill On Inserted Rows
vlookup
Re: Tally Text
Dates parameters/logic
Compare 2 columns in a worksheet.
finding Specific day in a named range
Autofill formulas b/t various worksheets
Creating Formula (Date)
Date Value & Date Format
macro - hide rows
graphng distributions
matching values
sumproduct variables
Problem with Date
Opening Excel sheet with macro's on XP machines gives error
Date Format problem
last day of month
last value in a row
Writing Todays Date to an Excel Worksheet
sequential counter
combined cell
multiple AND conditions with IF's
Using multiple IF statements
nested functions
LOOKUP or Offeset
Macros in XP vs 2000
multiple field returns
Using Sheet Name In Cells
concatenate question
Counting Rows
Multi level calculations
DATE
getting max value of unique dates in a range
barcoding
Moving from textbox1 to textbox3
Sum Dates
Remove Spaces
text referencing
Excel database query
Changing A1 to $A$1.....
Date Format
copying worksheets to other workbooks
automatic links
filter
Excel 97 - finding No. of Months between 2 date ranges
If then formula
Re: If then formula
MONTHLY PAYMENT FUNCTION - DAYS TO 1ST PAYMENT
return in excel
using spell check on a protected sheet
Turn off From: Cc: options under Office
Deleting Excess Pages
TROUBLESHOOTING VLOOKUP - PASTE NEW VALUES
Formula Help
Finding and deleting data automatically
Pivot Table Display
Multi worksheet data look up
emailing protected Excel worksheets
MouseClick as Counter
import data
Re: Copy subtotals
Spherical Coordinates
Deletion of non-existent links
Two Problems Adding Hours
This directed to John Wilson/or anyone else
Data Validation
testing
unhiding Column A - help!
Calculating age from date of birth
Spreadsheet play file then close
Array Countif formula driving me NUTS!
Changing date formats
Linking
Worksheets
Tan Graph
revision number of excel worksheet..
sumproduct formula
referencing a cell pointer in AVERAGE
Split Combined Name
Formula Help
excel data hidden
Re: Random Numbers
sumproduct
Counting