Excel Worksheet Functions [Archive] - Page 2

color counting
date function
[SOLVED] subtracting with vlookup?
[SOLVED] Trend data points
Counting Date Occurrances
[SOLVED] sum and weight average variable data
Linking data from one sheet to another?
[SOLVED] Reference a sheet in a formula by number, not by name
Hyperlinks That No Longer Point To Correct Cell If A Line Is Inserted Above it
Analyzing Paypal Spreadsheet. Finding First Instance of a Buyer
copying a cell shade from w/s to w/s
[SOLVED] Partial Match in an Array
[SOLVED] Cell sum offset using date
Subtotal(109,Range) recalculate problem
[SOLVED] Vlookup, using a cell that contains the table reference
[SOLVED] A UDF that won't update by itself
Merging two files
[SOLVED] Help with subtotals in Groups vs Filters
Append data from many to one .xls file
formula batching
Consolidating lots of individual items
Summing values according to the header
sum if with 2 variables
Conditional formatting using a formula
Data from Cell to Header on Another Worksheet
Copying Data from 1 Worksheet to Another W/O Row Spaces
Worksheet calculations table and list
[SOLVED] Calculating Hours across days
running total while cells added from fluctuate
[SOLVED] How to return the maximum value in a multiple results LOOKUP
[SOLVED] Formulas won't calculate. Just displaying as formulas
[SOLVED] If the result of a formula is a negative number, I want it to put 0
[SOLVED] Autofill problem
Cannot lookup values in more than one cell and link
[SOLVED] How to average lookups with multiple results
Needing more complex VLookup Help
[SOLVED] HYPERLINK function to a second worksheet in one workbook
[SOLVED] finding the minimum value in a column that comes after the maximum value
[SOLVED] Excel Macro - Date/Time functions - Overtime Calculator
Validate Mandatory Fields In Entire Document?
[SOLVED] how to modify array forumula and preserve brackets
Lookup? Countif? Index? Look up dates & move data
Match or other... i don't know what to use
trying to calculate blanks rows
Excel (2003) array formula taking too long
[SOLVED] using control + shift + enter
Assigning a value
Conditional format based on 2 cells - Excel 2007
Countif
Excel Graphing question
How to extract a string within brackets repeatedly
Multiple IF and MOD statements unsure about parentheses
Multiple lookup_values
Excel Grpah question using if statements..
Using AUTOFILTER with FREQUENCY - ?
Function used with % above certain number???
[SOLVED] Drop-Down Lists Not Appearing
[SOLVED] sum function help needed
[SOLVED] Time card
Possible to ADD or SUBTRACT in single cell?
Multiple conditions
[SOLVED] Concatenate and retain trailing zeros
INDIRECT AND changing reference
Ignore values in a percentage sum if they are zero
[SOLVED] Lookup function
password protected
Getting row value from cell
percentage fixed in time
[SOLVED] Assistance with a Vlookup
Autosum not working
[SOLVED] Substitute three variables
#VALUE! appearing on one sheet, but not another ?
'if' a cell is not having data show it as blank... How?
[SOLVED] Functions using a drop down menu
formula required to sort numbers as per given in sheet
[SOLVED] Matching criteria from a Virtual ( Non-Existing Range)
Sumif and concatenate
How to copy from a cell based on number
Stopping a formula when it comes across a blank cell.
Pivot table (calculation and/or sorting) problem
[SOLVED] average and vlookup
how to extract value one step lower then the max out of column of data
How to Change an Input Box based on input in another
[SOLVED] Help condensing a formula using new functions or array
Create a Reference To a Different Closed Workbook With Multiple Variables
Other option to "If" statement
Can you conditional Format a drop down box?
Conditionally lock cells based on value in input cell
Copying New sheets using formulas involving previous sheets
[SOLVED] vlookup help needed
Number Rounding
[SOLVED] Array Formula not working in one line
a percent of the highest above
Date last modified
[SOLVED] conditional formatting
Formula/Macro to separate dates (written in text strings)
[SOLVED] Sample Function Formulas
Dyanamic passing of formula parameters
Question about IF function
Copying info from formula results
[SOLVED] IF cell value >0, enter that value, if cell value is #DIV/0!????
Selecting multiple items in a drop down list
Remove #VALUE! Error
vlookup help needed!
Linking worksheets
Dates between Dates, If holiday then select this cell, If not select this cell, If em
[SOLVED] Weighting Random Numbers in Aggregate
[SOLVED] Using the Find Function
Still having problems with converting h:m to decimal
Need to sort number in col A to sum numbers in Col. B
[SOLVED] COUNTIF formula
function to multiply...
How to populate several cels with the same value when entered into primary cel?
Want to have Dynamic Conditional Formatting?
Always default to $
[SOLVED] Calculate/Sum a predefined working day
Help with analysing of qualitative data in Excel
lookup function help
Populate sheet name based on a formula...
Vlookup to get multiple rows of data
[SOLVED] IF function
IF Formula Question...
[SOLVED] Greater Than / Less Than
[SOLVED] Formula for last 7 days, 30 days
[SOLVED] Display Week Ranges
using indirect
basic database
Importing from word
[SOLVED] How to break ties in the RANK function
[SOLVED] How to count 0's in a range
if statment needed
[SOLVED] Need a Function Similar to LEFT / MID / RIGHT
Unique records with Minimum Value
Adding a word to multiple cells
[SOLVED] Date + Time Function
Using Lookup instead of Index/Match for left lookup
NPV Function
[SOLVED] Multi If Count
[SOLVED] Need to add income only between 1st and 15th of each month
Excel formula
finding right and second right values in a range of cells
[SOLVED] VLOOKUP with Multiple References
[SOLVED] link cells in different sheet
Looking up a value in a table based on 2 other values
If function reading formula
More than one condition in a MATCH funktion?
# of days between 2 dates
February day 31
Corect argument declaration
[SOLVED] Remove text from multiple cells
[SOLVED] Merge column data over multiple rows
[SOLVED] Cell border and colour with text
IF Function
[SOLVED] Nested if (and) statement - Operating leases
[SOLVED] Wildcard in path- relative to current sheet
Retrieving file from database with Javascript
[SOLVED] If, and, & or....
Joining text strings with "some" formatting in Excel 2008
Entering data in years and months and then analysing it.
[SOLVED] Find a value based on criteria in columns and rows
simple mathmatics worksheet with answer check
Conditional Formatting - comparing worksheets
Large File Size
[SOLVED] Index/Match issue
Function to move data?
Rolling 12 months
[SOLVED] A Compound COUNTIF() problem -- maybe??
[SOLVED] Conditional Format Duplicates
[SOLVED] hyperlink to varying web pages
[SOLVED] lookup data from table
automatic summary of data on another sheet!
figure data with any criteria
needing an if and an and
Is an automated Find & Replace possible?
Colour Coding ???
Maintaining inter-worksheet links following a sort
Numbers Exist/Not exist in a range
[SOLVED] Time function
Help with table lookup using array functions
Increment Numbers
[SOLVED] Cell entry as part of a cell reference
Vlookup function
CountIF Worksheet Help
Compare spreadsheets
Need LEN(TRIM()) equivalent one excel function
conditional formatting referencig another sheet
[SOLVED] Making a workbook readonly
[SOLVED] Help with OR Function together with IF function Please!!
[SOLVED] ignoring £0 total in cell
Help with dropdowns
advanced counting formula
list checking
[SOLVED] Data Validation for 5 digit alpha entry only
[SOLVED] How to look up a cell with that includes a hyphen (-)
SUMIF with multiple criteria
vlookup partial string of cell to values
How do I lookup a cell address where a certain value resides.
IF function
Problem in an IF definition
How can I trim a Cell without cutting a Word in Half?
[SOLVED] Using month in calculation ONLY if current year is 2009.
Lookup question
Conversion Rate Calculation (Formula)
Get some data from one sheet to other sheet
Seperating NUMBER TEXT NUMBER into different columns
Results from Multiple Tables
[SOLVED] How to apply a proper date format to an entire column?
Pivot table manipulation question
Time sheet Semi-monthly
[SOLVED] IF, DAVERAGE & DMIN functions and zeros
[SOLVED] How to pull only part of a cell
[SOLVED] Cannot get calculated time to equal inputted time
Grabbing values that will move
[SOLVED] Dynamic Range using Offset and CountIF
[SOLVED] Different Lists for Different Answers
What formula to use??
[SOLVED] Count If based on two criteria
Sum based on both row and column criteria
Duplicate Workbook for next month
[SOLVED] Nested IF function not working?
expand combobox through spacebar
how to create dependant combobox
vlookup formula
[SOLVED] Criteria values in COUNTIFS function
SUMIF with multiple criteria, one criteria a specific string
Wrapping a formula in Sum()
How to Rank Counts of Ages of Respondents
SUM only works in one cell
Conditional Formatting Assistance
Automatically change a worksheet reference when a new worksheet is added
Summing date from multiple date format named worksheets
how to apply a formula across multiple columns?
Date update
multiple vlookup results
Adding values, multiple criteria
[SOLVED] Vlookup & matching
[SOLVED] Table Lookup Question
[SOLVED] string concatenation
Simplified data entry for days of the week
[SOLVED] Counting each occurrence of multiple values
COUNTIF minus 1 problem
Convert inches to feet and inches
Moving duplicate data into new columns
Need Past Due count totals.
Inserting row
[SOLVED] SUM or lookup question
[SOLVED] deleting spaces/merge question
SUMIF Multiple Criteria or SUMPRODUCT?
[SOLVED] Grouping and averaging
get value from other worksheet