Worksheet Functions [Archive] - Page 11

How can I automatically execute a macro ASA data are entered in a cell ?
Database
COUNTIF
convert numbers to text
Slight change needed to formula?
Linking cells in a workbook
Link multiple cells
Header/Footer with "Install printer" error message...
Row Label
show the lowest value of two cells in a different cell
formula needed to calculate a date
Large Function
MROUND function??
Numbers not numbers ??
Show file properties when opening a workbook
Character spacing automatically
conditional linking
summarize a range
Linking cells in a workbook
Function not updating
Re: vlookup from variable matrix
Doing my head in
multiple nested IF Statements
Swap rows and columns
Project a date (from prediction calculation)
Indirect function with Named multiple ranges
Suppressing 0's in pivot table
Problem too large for solver
Excel cell backgrounds
How to put value in cell in Sheet 1 into cell in Sheet2
Replace/Format?
Re: Convert #N/A to number
Function in template becomes value in new worksheet
Floating 6 month average
Applying names.
Suppressing 0's in pivot table
finding the date in a sheet
Adjustment needed for formula
Changing dsn connection information (Password)
Pivot Table References
Re: Averaging Times in Excel Across Dates
Pie Chart Conditional Graphing
Is it possible to automatically change cell background colours?
Return the column letter or row number
ZIP code to text?
Getting a list of file names from Windows Explorer into Excel
how to write a new macro
incorrect values returned from simple calculations
SUMIF with multiple arguements
Formula help
MIN / MAX for specific value from other column
Inserting rows duplicates command button
Merge Labels
Binary calculation
VLOOKUP returning incorrect value
Need a Macro!!
trouble with vlookup
Consolidating??
Header format (and using VB for header content)
Bringing over text in a formula
Default Format for Comments
More columns needed
IF Condition
COUNTING
totaling sheets
query - search and find data in one sheet from another.
Excel 97
Filters not working...
Macro problem??
Formula problems
Re: Help with multiple lookup
Stop date changing each day?
Conditional Formating on value of cell and prev cell
IF function ??
Rounding sums in excel
Merge two worksheets into one with same independent variable
Readding Numerical value to ext
Selected Cell Colour
Automatically identify sensitive variables
Personal.xls
Sharing a workbook
Filters
Finding cell references
Suppressing 0's in pivot table - Please help
Re: GETTING RID OF #REF in VLOOKUP CELLS
Re: Explanation of formula
Highlighting cell content based on content of another cell
CountIF but based on two columns
Inserting rows under specific types of data.
Excel links on network: sharing file off network
Sumif function
Worksheet size
Need a function
Cell Formatted w/ Word Wrap--Force Text to Next line?
Cell Formatted w/ Word Wrap--Force Text to Next line?
Printing-How not to print a background
Help Needed - Formula
Sum Function
Vlookup result #N/A
I'm getting the #VALUE! error
Can't Remove a Macro from Excel Workbook
Extra quotation marks when converting to delimited text file
MATCH and VLOOKUP
Copying a sheet from one workbook to another creates a link
vlookup multiple criteria
Range
Links when opening a spreadsheet
Formula Cell Format -Change H:MM:SS to Currency
Totals when using filter
Show the product of a formula calculated in spreadsheet one in spreadsheet 2
Time Sheet
NETWORKDAYS Help!
Copying Goal Seek and Solver into a Power Point presentation
Comparison
Re: Force calculation of all formulas in sheet
Formula's across multiple sheets
How to copy formatting in a Concatenate formula
Counting Cells With A Specific Color
Links
Grams to Pounds
Percent ranking error - please help!!!
How do I create a formula that picks the last entry
Re: Expiration date for Workbook
Pushing Separate info to separate sheets
moving worksheets between files
calling linest from VB application
Re: IF statement syntax error when referencing another worksheet cell
Replace cell references
Re: Multiple values in a single cell, and validation
Hiding Rows
Sorting without moving background color
importing text files
how do I insert a function to..
need help printing rows & headers w/macro
removing attributes...MAD as HELL
Count Unique Entires -- with conditions
Converting Date to Number formats
Solver in Excel 2002
Is it possible to automatically control zoom level so resizing a window doesn't hide anything?
Time Sheet calculations
EXPORTING CONTACTS FROM OUTLOOK TO EXCEL
Replace =RAND() with =ABS(RAND())
PivotTable question
Solver
Keep pivotchart formatting when data is refreshed?
Data Validation-List
Finding cells
Statistics, #N/A and dynamic range problem
Help with Division Cells
Re: Statistics, #N/A and dynamic range problem
Does it get any simpler than this?
Multiple VLOOKUP?
Re: Excel Formulas for date & time
Copy formula down
Unable to Sort Multiple Columns
VBA user-defined worksheet function
Cannot merge cells, old spreadsheets, new Excel
Array formula issue
lookup or match or max???
Reference for a range
Excel Formulas
Substitute Character
new window & character size in formula bar
Newbie needs help moving columns around.
Workdays with Saturdays for Dummies
- sign does not work
macro
update all numbers in a column by a percentage
reduce excel file size
Need something similar to MATCH or VLOOKUP
Add Data to field
Counting cells
Sum error
A rather involved "if-then" spreadsheet. Anyone?
LOOKUP DATA
Searching a column multiple times for a value / returning a running total of values
Merge 12 worksheets
calling vba scripts
Was wondering if anyone has a solution for this
Do I use VLOOKUP???
Conditional Formatting
moving cursor to nect cell automatically
Location of Large
sum top values in a range
Deleting duplicate records
Cell Function question
Re: Counting Unique entries in a list eliminating Blanks and Merged Cells
Re: Mergingg worksheets; Possible?
Re: Translating "coded" import data
Re: Sorting using an imported list
Sequential cell reference
CONCATENATE Text and Values
Sequential Cell Reference follow-up
How to direct user to enter certain cells from drop down list?
ALIAS of EMAIL ID in EXCEL Cell
excel alert message
automatic worksheet identification
accrint()
Experts kindly help!
Experts kindly help
Formula needs more than 256 columns
IF function
Pivot Tables
Worksheet Atchments
VLookup: Range_Lookup
Conditional Formating
Convert hours and minutes into minutes
Re: insert date in a column when information is entered in another column
Buttons
"Lock down" date formating
Merge Worksheets
Conditional Formatting, Formula Help Needed
Re: fourier analysis
Moduals are appearing randomly
RAND() in Excel 2003 - revisited
Excel macro book
Recognize a BLANK cell? Or Null value?
custom formatting cells
Time Difference shown as fraction of hour
Running totals across spreadsheets
auto save
Copy a column into many worksheets in a workbook.
Cells with GetPivotData Function show Blank
Tangent to angle conversion
Copy Formula down for Gord Dibben
prevent Excel from EVERautomatically converting numbers to dates
Using Date
single quote removal
Re: Matching, Cell Coloring, Greater than
x
Vlookup?
COMBINATION formula
Calculating a based on criteria in another cell
18 digit number
count # times words appear in column
Poisson?
Calculating Age-
SLOPE/INTERCEPT problems with missing data
Question about an argument, in an OFFSET dynamic range formula
MATCH Function based on specified occurence (i,e return position based on 2nd occurence)
Send add result to next sheet
question auto save 2000
referencing
List Box
Excel File size when using large amounts of data
How can i know how many rows in a worksheet?
Combo Box Control
Vlookup - Using a named ranged for col_index_num
Testing for Errors simple function.
Date Format