Excel Worksheet Functions [Archive] - Page 5

formula matching 2 separate factors to lookup a 3rd entry
Extracting the filename from application.getopenfilename
Help: Automatic addition in Excel?
[SOLVED] Unmerge merged cell and put value in all cells
Naming last entry in a column
COUNTA ignoring formulas
[SOLVED] data formatting
[SOLVED] Parameterise worksheet formula (without VBA)
Repetition
How to track my insurance details
SEO Meta Keyword Worksheet to Calc Stats
[SOLVED] Data Validation question
Indirect function syntax
Naming last entry in a column
Sum across multiple sheets
Rows of data into columns
[SOLVED] Checking for multiple instances in an array
How to sum a range of cells that satisfy an argument
Nesting AND and OR function within an IF
Sum values from ms query
[SOLVED] Simple (?) SUMIF Problem...
Advanced filter macro
finding like values in a column
function on sorting and matching
Find data in table but return HEADER
[SOLVED] Multiple Database functions
Summing Values Between Two Days
Better way to write a sum IF formula?
[SOLVED] IF statement does not work?
if result in another cell is true
[SOLVED] Find 10th value after max in a list
[SOLVED] sumproduct help?
[SOLVED] IF or COUNTIF Formula?!?
Complicated Averaging in 3D
[SOLVED] Vote count formula
Sum some how!
Date posting
Fluctuating status related to Date
Scoring conversion
[SOLVED] Return one value per day (from hourly data)?
[SOLVED] sum formula question
Avoid #Div/0! in Sumproduct
Data Analysis Add In - Storing Multiple Regression Coefficients
Array Formula Advise Needed
[SOLVED] I want vlookup to return results based on different sexes and ages
[SOLVED] logical test not working
[SOLVED] Increasing value of one cell based on another's incremental value
I want vlookup to find a range, and return highest value in that range
[SOLVED] Count If and Return of Column Headings
Adding Cells from Multiple Tabs
election spreadsheet function
[SOLVED] Advice required for this function
need solver to call VBA function
Automatically copying row to another workbook (and updating)
finding range of numbers in a column
Search function in massive database
"merge" using functions
[SOLVED] Getting 2nd to last number in a range
[SOLVED] Vlookup results display "0"
[SOLVED] Macro Referencing Text From Another Cell
[SOLVED] LOOKUP Query
Joining two Sheets as one.
Extracting Values using GETPIVOTDATA
[SOLVED] List Box Extension
I want to know about "pv" "fv" and "compounded intrest" etc
[SOLVED] Automatic Target adjustment
[SOLVED] COUNTIF with partial match?
[SOLVED] Can a cell result be a range name?
automatic sheet generation
[SOLVED] employee timesheet with overtime
create automatic reports
[SOLVED] Lookup value for certain time
column problem
[SOLVED] reset countif problems
[SOLVED] Date format problem
Formula to copy data from 1 w/sheet to another and add data to new line
[SOLVED] Questions about the MinA, MaxA functions
[SOLVED] Find Min in a column while excluding 0 or errors
[SOLVED] Sorting (or maybe filtering) worksheet with multiple data in cells
[SOLVED] average of the first N numbers in a list
How to write a Time based function
[SOLVED] User defined function based upon page of calculations
Why does a Named Range causes an error when you minus it?
AddIn spreadsheet function does not appear in dropdown list when entering function
[SOLVED] How to calculate AGE automatically using FUNCTIONS?
copy sheet to new workbook (print area)
[SOLVED] Utilizing iteration in conjunction with Excel function
List source from other sheet
Sum range with two conditions
Need help
Get list of words in a string
Formula functionality issue, 0 value potentially in 2 fields, calculate then post.
Row fill with defined values?? help!
Formula to help with picking part of cell data
Simple way to keep 2 sets of data represented fully in a 3rd?
Date of last year same day
Can you do a search in a dropdown menu?
Converting time from seconds
Editable Validation Lists in a Cell
[SOLVED] Conditional Formatting a Row
Copy and Pasting non-continuous formula
[SOLVED] Minimum non-zero within array formula
[SOLVED] Lookup failing
[SOLVED] More than 3 conditional formating per cell
[SOLVED] not show 0
Using Coloured Cells for IF Formulas
[SOLVED] Having a date appear only when date occurs
[SOLVED] Date and Time Question
Duplicate data two field find the duplicate data
[SOLVED] Word List and Count from a string
Problems with worksheet calculations?
[SOLVED] transformation of data?
IF Statment Help
Help with correcting a function
Average every nth cell in a column
Using Check Boxes to Display Data
Looking for way to list all other sheets on 1 sheet
How to Delete Unused Area in Worksheet
Referencing data from one workbook to another
Show items in pulldown as typing
remove HTML codes from worksheet
Average percent of a range
Unique Counts
Formula to return column heading dependent on number in cell
Excel 2007 and Music?
[SOLVED] Removing Auto Link to Info in Another W/book
Reference different sheet for hyperlink
How do I make Excel arranging the numbers for me
Cell reference in CubeMember function
Formula for working out winner, 2nd etc
Counting Orders/Rep/Month
Formula for working out winner, 2nd etc
Preventing re-calculation of formulas
condition not returning False
change number to text
[SOLVED] Problem using ISERROR
Comments - Hiding the red corner?
subtotals ( nested )
weekday
Sum function only goes to 30! I need more!
PMT function: Did i do it correctly?
conversion to thousand
Problem with SUMPRODUCT
Drop Down Menus with IF Structure?
Need Formula to calculate project end date
Formula - Find Cell and Reference another
Concatenate Function Question
Need two cells to equal a certain number
[SOLVED] NetWorkDays Formula Problem
[SOLVED] Combining =REPT and =INT
Finding similarities/differences between columns.
[SOLVED] Prevent deletion of a cell with no cell protection
Separating values.
Select top 3 when date changes
[SOLVED] Calculation based on % of cells
Matching the values of 2 columns...problem
Only show formula results if not 0 (zero)
A complex little query about tracking items in stock with variable cost prices
Absolute Reference In Formulas
Database help
I need help with complex VLOOKUP
[SOLVED] concat function
subtotalling in excel
Adding times in a filtered list
[SOLVED] 'HLOOKUP' with more than one 'Table_array' possible?
[SOLVED]Average in filtered Data
Reference to Merged Cells
replicatable "random" numbers for homework
Hiding Options Based on Individual Worksheet Completion
If Statement in Balance Sheet
Nesting IF THEN formula correct here? Using Excel '03
IF Statements
Formula trouble using excel database
[SOLVED] Counting rows based on different criteria
[SOLVED] Conditional Format IF cell is one of three values
[SOLVED] Average variable number of cells
Calculating StdDev combined w/ If function
Conditional Formatting Based On %
SUMIF Function help
Function to find first non-zero value in a range
[SOLVED] How do I count how many times names appear
sumproduct formula
Extend count repated
[SOLVED] Help with writing a countif function
[SOLVED] IF Formula
[SOLVED] Counting # of Cells that are overdue
[SOLVED] Dates
Monthly Progression
Find and Replace from 5 worksheets
Define Sumproduct range indirectly
Count unique values with criteria
auto numbering labels
Extracting multiple records according to a criteria
Invalid range names
[SOLVED] VLOOKUP and still have typed text in cell
Highlighting a selection
Hortizontal Lines Missing?
Keeping only numeric character?
[SOLVED] Is there anyway to use Vlookup for negative values or a range of values?
Removing spaces from text
IF Stmt based on color
Display 'UNKNOWN' in a cell if the criteria doesn't match
Using Excel Forms
Calculate duration from start and end time entered
[SOLVED] SUMProduct Intervals
VLOOKUP: Return value from column left of lookup column?
Limit on Nesting IF/THEN Arguments?
Birthdates and return name function
Three criteria formula required
[SOLVED] Trying to create mileage log from one sheet to another
[SOLVED] Finding Matching values in cells
[SOLVED] vlookup and offset?
format cells
[SOLVED] max and average
Count If problem
[SOLVED] Summing up cells based on values of other cells
worksheet name and cell value
[SOLVED] Averagif/averageifs?
IF formula / target performance worksheet
How do you create a formula for addition in single cells
[SOLVED] Getting rid of #N/A with MATCH & OFFSET
[SOLVED] Multiple IF's and AND formula
Index Match vs D Function to summarize Data
Entering Codes into Excel?
[SOLVED] Dropdown to give value to ANY cell
FV with a Increasing Payment
How to search and extract specific words from an Excel worksheet ?
[SOLVED] View /Print selected options contiguously separate page
Typing two sentences in same cell
Locating data in a table
Formula to omit Specific dates
linked cell
Vlookup formula to grab to variables!
Dependant drop down list and database value
[SOLVED] Need an IF formula to recognize partial TXT but out number
Reminder in excel?
[SOLVED] Finding text within a string
Return max date information
[SOLVED] IF Formula?
Need VLOOKUP alternative for duplicate values
Adding days to a date
sequentially displaying a value from a range
[SOLVED] Most repeated
[SOLVED] SUM MAX or Index/Max??
Calculating monthly average
[SOLVED] extract street number from address
[SOLVED] SUM-OFFSET Error
Function like ISBLANK, but not exactly
Shift - Day and Night, working hours out
[SOLVED] Days & Hours B/t Two Dates & Times