Worksheet Functions [Archive] - Page 25

Using range names in formulas
DSUM or SUMPRODUCT wont work.
count blank cells
Adding a column of numbers
countif for multiple variables
Vlookup the most current information
Array with multiple criteria problem
Splitting multiple data from 1 column to multiple columns
**Trying to use answer from another formula cell in another formula
Re: More explanation
Multiple If Statements
=EXACT
Need help removing leading zeros from a list of numbers
Radio Buttons
files and folder manipulation with excel
Re: Excel Time Duration Formula
Nested IF Function
IF formula with errors
Worksheet names used in cells.
validation list
If function
Re: Adding a row in a linked worksheet
autofilter and subtotaling
Re: validation list
Random Sample on multiple criteria
Format
Copying HLookup Formula
Changable Cell reference
count column entries
Count Unique Items
Re: Calling Excel function in Access
Formula Has Stopped Working
help needed to count instances?
copy & paste from other worksheet - but not allow to cut
Default Comment Format
Trim relative cell reference not updating
Re: Keeping one cell constant in formulas
Excel '97 and Auto Save
auto colored cells with days
Naming a cell
COUNTIF
dollar function
EXCEL IDENTIFYING SIMILAR INTEGERS
Amoritization
Importing time into correct format
help moving info from one sheet to another automatically
Re: Formatting Workbook
Assign a text to a Cell function
Function to pick Peak or Min from table of values in Excel
FORMULA
Formula for automatically populating with data entered
Linking Workbooks
Data Validation
Countif Across worksheet tabs
Re: vlookup excel
Counting Consecutive Days
excel macro - maipulating toolbar using opening maro and closing macro
Re: Oh boy! Call me Nuisance Mr FK.
Conditional formating - cell contains a formula
Selecting Dates in Excel
Formula to rid of DIV/o!
IF function containing certain text
Re: Copying and pasting VLOOKUP formula
Workday
Finding out a position in a range
Not sure what formula is needed?
Questions about IF Function
Excel Functions and Macros
New Date-New Sheet
Identifying miskeying errors
Sumproduct
Change Cell Entry To Uppeercase
formula shows in cell when trying to copy
question on conditional formatting
Date Formats in Excel
Something is not "right"
Excel 02 ___Combo Box Format
CountIf function
Excel - How To Search For A Number In a Cell Containing Several Numbers
Copy and paste between workbooks
Reference a cell with text and numbers
Excel formula that will delete a row
Works to xp
Date Function with literal date does not resolve True
Display #N/A as 0 in VLookup
Re: Make n/a go away
Help with a Macro
Re: Add Space to Field that is consistent format
Percentage formulas
Linking issue - stumped
Linking from sheet to sheet
One change affects several other cellrange references
Re: OFFSET I think
sum if help
Re: DSUM Criteria and Excel Help
Copy a Column But Paste it as a transpose and link together?
Worksheet errors
local variables?
Lookup solution
Skipping values in scrollbar range
Conditional formatting to change colour based on part of a cell
Excel macro !!
Peo Sjoblom: multi lookup
Protecting Individual Cells
Re: Data Summary in new sheet
Re: 2 Criteria Count and Sum
Sorting in numerical order when numbers and alphas are used
Placing the "&" symbol in an excel header
Inputbox in Excel 2000
Tri
In IRR period in data flow compared to period in result percentage
combo forumla help
Re: IF(COUNTIF(
filling formulas down a lot of rows
SUMIF with AND and OR
Phantom Links
SUMIF times 3
Sum if
SUMIF Equations
Strip Character from Right
External Data refresh query
How to get PROPER to maje exceoptions
Re: Strip Character from Right
How can I keep "#N/A" values from appearing in VLOOKUP results?
In IRR period in data flow compared to period in result percentage
Re: Help with Advanced Filter Comparison Criteria
Rank function returns '0'
Re: Text not fitting in a cell
summing number of date entries in current week
Re: Linerar equation woes
Re: troubles with time
"File" menu item disappeared from "Worksheet Menu Bar"
ç (c-cedile)
Conditional formatting
computing numeric with text
Function Evaluation not what I want
How can I avoid typing the (:) when typing in the time
TEXT=1 formula needed
Re: How can I avoid typing the (:) when typing in the time
need function help
Trying to get a new formula
Re: Extract Multi-Sheet Values into a Summary-Sheet
Problems using Excel 97 worksheet in Excel 2002
Re: time difference between 2 different time values
Dividing function: can you define the decimal place?
Re: Dividing function: can you define the decimal place?
Re: Can't work formulas in sheets copied from the web
Making CurrentRow a lot 'clearer'
Re: How I can multiply between text and number?
sound activation
Prevent access to macro's if sheet is password protected
Re: Prevent access to macro's if sheet is password protected
microsoft excel version 6
AVERAGE of row gives no result
Rank
Rank
Re: Help, Formula Problem
Problem with NOW() function
Re: Problem with NOW() function
problem with formula
using IF & AND functions in conjunction
Trying to count the number or customers of type x for subsequent time intervals
total worked hours for a week
Re: Trying to count the number or customers of type x for subsequent time intervals
Jessica, Payroll Template
Index & Match versus V & H lookups
Mutiple line display in cells that contain formulae
Re: Index & Match versus V & H lookups
Get rid of Duplicates
blank cells
correct formula
lookup?
Repost - Using SUMIF and COUNTA
EXCEL and OUTLOOK
filename in Excel
Securing formulas
Problems with columns, macros and auto filter
A macro to open files, refresh data, and close file in background?
Re: A macro to open files, refresh data, and close file in background?
Re: Help Please
Re: Repost - Using SUMIF and COUNTA
Re: Format cell using Validation rule
Weekday
Count number of occurances in column
Re: Count number of occurances in column
PLS;HELP TO RANK STUDENTS POSITION
formula for balance & over expense amount
Bell Curve
Excel 2002, If Functions Problem
Re: macro and insert rows and count
calculate date difference and use result as condition
simple formula, excel/VBA
Vlookup not quite what I need.....
Find last value in a list
ROUND TIME TO NEAREST QUARTER HOUR
"Average If Not Blank" Formula
Concatenation giving #VALUE error?
COUNTIF help needed!
Counting the # of occurances in a column
Between
inverting text
Excel Lookup Problem...
Sort by more than 3 columns
Cannot shift objects off sheet
Re: Is this formula correct?
Newbie: Counting the number of words in a column
SUMIF and dynamically inputing info
Quarter Date function
Monthly payment cells
Making control invisible crashes Excel
Access
Dropping test scores
Finding characters
3D look up. Help
Adding new rows to a list when Protection is on
Re: Find last value in a list
Display alert
data to chart
Re: Excel 2003 can't change cell color
Please HELP...nervous wreck time calculation
Re: still #N/A formula doesn't work
Please HELP...nervous wreck time calculation
IF Function and the use of Wildcards
MAX function and "visible cells only"
Display alert
Colours
Re: Find highest value in column
Personal.xls
Re: Mulitple COUNTIFs ?
Workbook settings
Formula Question
Macros
Change text in worksheet to all caps
Hyperlinks between Excel 2000 and 2002
Link to PowerPoint from Excel
RE: changing text to text according rules
Performing conditional calculations based on character strings
Static Date in Formula
Formula displaying in select cells
Use dropdown list to display more than one record from a table
Trouble with Check Box(es)
Character limit
Workdays (inc Sat) formula
help me
Re: 2 File If Statements
countif problem
Linking group of Option Boxes to Drop-down list values
Re: Advanced Filter List Range from within a Macro
Re: DATE Functions???
array Formula for date counting