Worksheet Functions [Archive] - Page 9

EXCEL
Re: Using .bmp or .ico for custom excel toolbar buttons
excel 2000. format tab color, available?
Repeating Numbers In Numerical Order
calc hours from date/time to date/time
Re: Summing multiple categories - Help!!!
USER
Automatic links shows up as a #Value# error in EXCEL XP but not in EXCEL 2000
Compounding
Multiple Source Data for what-if-funtion?
Sheet backgrounds disappear intermittently
Re: hlookup to propigate validation table
Re: letter and numbers substitute
Re: Exporting multiple worksheets to one .CSV
External References
External References
EAN Check Digit Calculation
Assign a multiple commands
Unpivot
Re: Comparing Two Text Based Lists
How to Convert Numeric Values into Text Values with a Formula
Array Function - cell to remain blank
Array Function - cell to remain blank
Change sign of entire column of numbers
Re: Copy Data to Sheet2 if cell in Sheet1 is not blank
Finding Last Contiguous Column Cell Entry
RANGE NAMES
Re: Paste Less Decimal Places
Locking formulas in cells
How to create formula for combining two cells as one cell
Data
Creating a Custom Excel Formula
Tabs
More help on a current issue
Credit Card Number Suppression
excel form lines /and print command
Find Wont Find Value
=Rand() Help
user defined date/time format
How to convert text to numbers?
Coloring Subtotals
Convert seconds to mm:ss
Excel/Percentage
Date format in cell
Highest and lowest value from column
negative hour/min values
Howto: relative & absolute cell references
Linking workbooks
Re: Autofilter and zero's in blank field questions.
Macro / close a workbook without saving
Copy Unique Records ... Formula?
Display ASP Results in DIFFERENT worksheets
Pivot Table and Countif Function
excel automatic add-ing
manual calculation doc
Dynamic Range
Sorting based on a drop down list
Problem with INDEX function to return top 3 objects and sizes from a list
using cell background color as basis for formula
finding quarter date information for accounting
HLookup
Relative Cell Reference when recording macros
Import Excel into Access
Assign Macro to AxtiveX objects
Need help!!
Detecting Cell Format Using Named Formula
roots
A B C D column names and 1 2 3 4
Average
Help with formula
OR Function Problem
auto SUM a FILTERED List
Modifying a Macro - Auto Save WorkSheets as Workbooks
TIME FUNCTION CALCULATION
Conditional color based on formula in cell
IF
How to display Col1 and Col5 for the largest 3 values of Col5
Function
COUNT DATA
Problem with date in Combo Box
Single word subjects and anonymous posters
Formula text showing instead of result...
HELP HELP - COUNT IF A SPECIFIC MONTH
Increasing invoice number
Seek highest value, but reflect column header instead
Re: Excel Word Count
Grouping
min conditional statement
Arrow Keys
Import text file drops leading zero
Macro to change text color
countif
sql.request help
Tool bar functions greyed out!
Finding Last Relevant Cell
Chart question
How to code an event to call a macro?
Re: Null Value - now a $2,000,000 Question
show repeated item automatically
Auto form number
Excel formulas
How to create drop down list having options to the right of cell
LOOKUP to various different worksheets
lookup for a range around a cell in another workbook
Is there a Subtract If function
remove blank cells from list ?
Round values to 0.05 or 0.00
SumIf where sum_range contains text
Returning cells with ID column in another sheet
Sendmail in Excel
DSum function
Devide value by 0 or ""
Formula to count cells ignoring highest and lowest values
convert column number to letter(s)
quick formula question....
VLookup Help
Look up
Re: Lookup for worksheet name
conditional formating limits?
My brain hurts...
EXCEL
Refreshing the displayed rows
Count # Workdays b/t two dates?
unselect option button for printing
Re: Count # Workdays b/t two dates?
Conditional Formating based on other cell values??
hours x rate calculation
Referencing different workbooks
insufficient memory
Adding months to a date
Calculating weekdays
Countif value between two dates
Function to figure vacation accrual
Open to a particular cell in a particular worksheet
If & SumProduct
Re: Cell Reference Question
Copy formula problem
Formula Help Needed to Spread Days Across Months/Years
Moving to next row
HELP - formatting issue when upgrading from XL97 TO XL2002
Counting Filtered Records
Re: Finding Text Value in Column
Re: Vlookup & if Statement, PLEASE HELP!!(kevin or george??)
graphic representation of a formula with one variable
formula
Formula
formulas
Function to find the second largest number in a series of numbers
retrieve disk space
Data Tracking with Template Wizard
formula
text wrap problem
Formula Question - Multiply with Divide
variable cell references in function
Macros
Repeating characters to fill cell width
Conditional summing question
Formating Text/numbers
How to read values off graph?
Ensure accurant entry
Re: populating cells using rank in other sheet
Need VBA code or MACRO to disable the printing of Excel worksheets
Workbook print in black and white
Help: Calculating loan payments
Copy Duplicate rows
Number Formatting within an If statement
link cell content and format
Dragging Formulas
formulas
=average(range) ignore blanks & zeros
Internal date format
"cascading" formula
Macro
unit conversion formula
How to copy selected cell in a work sheet to all worksheet
delete alternate columns...
Add-In Link from Excel to Access
Need help sorting a database
Rounding numbers
rounding up numbers.
Cell reference in formulae from text in another cell
Problem with copy & paste formula
need help with formula(s)
Howto: Filling in values based upon a particular cell
Borders not showing in print preview and not printing
OR function
#VALUE error when summing rows containing blank cells
Nested IF's and VLookup Tables
Excel
Re: Allow a circular reference
SUMIF function
Data Validation
Conditional Sum based upon text value
COMBINE SEVERAL WORKSHEETS INTO ONE???
Convert text to numbers.
Date Calc.
Merging Data from several worksheets into one worksheet
Problem with indirect from cell on external worksheet
Home Loan calculation
timeline?
Re: Sheet copy with absolute reverence
SUMIF used in a link
adding/deleting cells in a named range of cells
column to text for multi-line text cells
turn off autofill in a cell
lines
What formula would show me I already entered an invoice number once before?
How do I get a filter to "UPDATE" the rows selected?
COUNTIF
Name conversion
Finding 4600
Help
Custom Views in Excel 97/2000/XP
Custom Views in Excel 97/2000/2002
Circular Formula (Reference)
How to calculate 12 months from "Date Added" field
editing chart source data
RE: Generate new document with data
I Need To Calculate Total Hours
Re: count cells that fall within a range of numbers
Round To The Nearest Thousand or Million
Count example dosen't work
Pivot Tables - change flat file data from the pivot table
VLOOKUP
Convert Text to Numbers
Gridlines Not Printing
Time Based Formula
find information
Macro to Move Entry to Last Line of a List
Can't see formula result - only see formula - Excel 2002(OfficeXP)
fomulas
Colors on a WorkSheet!!!
Countif with 2+ Criteria
Adding time
Re: How do i fill one column based on another?
Dates
Re: Let's try this again
Dynamic Links/ linking numerous pages on spreadsheet
Re: trying to count a range with criterion in different columns
Combo box instead of command buttons
VLOOKUP - "Close Matches"
Formulas
Highest Number?
If goal not met 2 out of previous 6 days
Re: Lowest number in a row
Breaking apart a number in a cell into seperate cells
select rows between 2 finds
Add a trailing comma
AutoCalculate Problem
Special today Date challenge question