Excel Worksheet Functions [Archive] - Page 6

[SOLVED] How to write a condition to catch missing data
[SOLVED] Autofilling a colum that has different #'s and spaces
How to automatically convert numbers
Using Variables when defining named ranges
Linked drop-down lists
[SOLVED] Lookup Sum Function
Validation - No Duplicate Numbers From List
[SOLVED] Aligning rows in excel
[SOLVED] Conditional formatting and dates
Subtotal Formula?
QTD Function
[SOLVED] Determine If Last Character is Number or Not A Number
'real-time' filter?
Multiple IF conditions with dates, how to
[SOLVED] Using "IF" with date returns an improper "FALSE"
[SOLVED] Embed/Nest Three functions.
MS Excel – VBA – Sorting worksheet - CODE
Spreadsheet Date help
[SOLVED] Combine several lines of text into one cell
Excel formual not getting copied
[SOLVED] hlookup to skip past first found 'lookup_value'
Need help to find data from multiple sheets & paste into a new summary sheet in excel
[SOLVED] Array formula
[SOLVED] Drop Down Box Help
Formula Coding
Search / find questionmarks (?) in text
[SOLVED] Calendar
IRR calculations Annual vs Quarterly
[SOLVED] Function which references active or selected cell
having vlookup only consider unhidden (filtered) rows
Toggle jpegs based upon number in cells
[SOLVED] Using text and TODAY function
Conditional Formating- Duplicate detection within a range
UNIQUE formula in Excel
[SOLVED] Check multiple locations for common numbers
Excel problem
returning entire row based on single or multiple criteria
Max function
Trending in Graphs
[SOLVED] Address Match
Lookup THEN calculate
Lookup
PMT Formula
Get first numeric value in a row without array formula
[SOLVED] Populating cells when there are duplicate conditions
Function in spreadsheet calculating incorrectly
Read only excel sheet
Count if Falls Between Two Dates?
Make sure Cell is filled before going to the next cell
Ignore Spaces
Earliest and Latest Dates from a list of names?
If Formula
Formula to find time that data changes
Trailing covariance with INDIRECT function
If+replace
IF/Then statememt
[SOLVED] Conditional formatting with formula referencing range in different cell
Combining variable length lists from multiple worksheets
[SOLVED] Aggregating data without a pivot?
Listing Specific Values Based on Criteria (Including Duplicates)
[SOLVED] vlookup help
Address Book Duplicates
Using INDIRECT in VLOOKUP to achieve a relative vlookup
[SOLVED] =minif?
excel stock list
Storing multiple information from one formula
Combind IF,AND OR
[SOLVED] Copying a long formula to another workbook?
[SOLVED] If statement
[SOLVED] Sumproduct query
Using checkboxes to remove names
Convert AlhpaNumeric to Numeric
Find optimal sum from list of numbers
If statement - set formula problem
[SOLVED] =SumIf calculation question (spreadsheet)
Fixing #N/A in VLOOKUP
[SOLVED] LookUp Values and Sum
[SOLVED] ISNA and vlookup
If & AND
[SOLVED] Data transfer question
Sumproduct with date range?
Cell page location
Shared workbook cannot update object
[SOLVED] Create reference formula from text
Help please working up a function
[SOLVED] Trimming cells (not spaces)
Sum of stats in two seperate excel files updated weekly
[SOLVED] Index Excel sheets
[SOLVED] If function 10 condition
worksheet evaluation
[SOLVED] Networkdays
[SOLVED] Sum IF (2 equal values)
Sum function blank fields
Invalid cell reference
IF statement?
[SOLVED] Two different arguments in one cell
Sumif problem
countif problem
Calculating and displaying highest number of dulicates
[SOLVED] Rounding Timesheet to quarter hour
[SOLVED] Using a value to adjust a cell reference
Calcuting spreadsheet formula
[SOLVED] Linking a cell through a function?
count in column A how many times LH appears and values in B <2
[SOLVED] Calculate hours and minutes between two dates/times
[SOLVED] VLOOKUP Personal.xls - how to make values update automatically
[SOLVED] IF priority value changes then move $ amount to a different column
[SOLVED] Multiple worksheet lookup
IF Statement / Last Business Day
Clear all filters
IF Function & Additional Calculations
Painting Cells Formula
calulating exact age (date)
Ranking Formula (Part 3)
Counting down from a date when it is 150 days from today
[SOLVED] Project Next 12 Month End Dates
[SOLVED] CONCATENATE Spacing Issue Due to String Lengths
Need help with excel fun.
Need help with Sales Database
[SOLVED] Counting Inventory
[SOLVED] Using labels to count cells within a given date range
Max (and min) excluding errors?
Weekday Function - Current month only
Table value lookup issue
using indirect
vlookup question
Calculating Months before or after date
Lookup and replace help
How can I "rank" a column of numbers.
How to use an if statment to test for empty range
[SOLVED] how to count the number of 0's
[SOLVED] Merge certain rows, of different sheets, of the same workbook
Ranking Formula (Part 2)
Ranking Formula
Auto take data from a website and implement it (currency feeds)
Creating a chart
Merged cell autofill
commission structure formula
cashflow increase
Insert Picture in a Header
Rounding up in increments
[SOLVED] Merge duplicate records in single record
Lookup function in more than one sheet
[SOLVED] Index Match: Insight needed
[SOLVED] need formula for: two columns, "greater than" for each pair
Find the five most repeating number w/ criteria?
[SOLVED] Flag each group in col C if one or more flag in col A
Percentage Subtraction
Schedule updating formula stopped working
Data type query - please help
Adding digits onto a string of numbers
[SOLVED] Quartile with criteria
Problem with sorting
[SOLVED] two criteria - multipule matches that are the same - 1 answer to be return
Forecast vs Baseline
[SOLVED] Lookup referance numbers
[SOLVED] "indirect" function with variable parameter
add more criteria to SUMIF
Look up question
[SOLVED] IF error
[SOLVED] Calculating one number three different ways?
[SOLVED] Comparing Two Lists for Duplicates
Enter variable, return results from several columns
Confused on method to lookup using 3 - 6 criteria
functions
Subtotal including a Count and Sum
Naming a set of worksheets
[SOLVED] Look up a rate based on another value
[SOLVED] automatically adding days based off month
[SOLVED] Two trues return "Error"
Calculating Formula on spreadsheet
Newbie here, sorry. Need help with formula (I don't know the lingo much).
Returning a defined value for a date that sits between multiple defined dates
Cascading Data Validation -eliminate duplicates
Adjusting Chart Ranges
Issues with Shortcuts
Stratifying Negative Values
[SOLVED] Get cell Address of Max Number
IF function to profit when shares are up & down
SUMIF when neighbour cell meets criteria?
Return the heading value of MIN Range
[SOLVED] Issue with VLOOKUP & Grid names...
[SOLVED] Using sumproduct to sum networkdays between dates with criteria?
COUNTIF Question
Trying To Write A Complete Sentence Based On Columnar Data
Problem adding time values
Countif between time ranges
Frequency and sumif
Calculating late fees every month by date
PLEASE HELP...so complicated
Pivot table - calculated field using 'IF'
Ensuring one number is a whole number greater than the other
Lookup within in Same cell as reference
counting days problem
[SOLVED] Appending Text to Cell Values
Taking figures from the week before -
SumIf Excel 2007
Will an Index work
countif with multiple criteria
[SOLVED] If function to return no. based on 2 cells?
Flagging all Duplicates
Verifying value is present (Vlookup?)
[SOLVED] Sorting Problems
Clicking on a cell to take you to that cell's reference
[SOLVED] VLOOKUP - Multiple Data Range(s)
[SOLVED] randomly selecting a cell from a range
[SOLVED] Sum based on date range
[SOLVED] argument separate overtime from regular
Two criteria lookup
How to make a reoccuring if then
[SOLVED] Using cell text to lookup a certain worksheet
How do I find data in a table based on an input cell?
Formula Question?
[SOLVED] Numerical Logic colliding with Text
Better than if function?
[SOLVED] Multiples of a # formula
Function to compare setting to another cell
matching a cell between 2 sheets...
Integration of a function over some interval
find the larger number
Copying an array formula
using a cell value to locate a cell address
Concatenate question.
Sorting duplicate values in a column
[SOLVED] Using a cell on another worksheet as input for data validation
[SOLVED] Nested vlookup
Movie Theater Matchup to Registrations
using COUNTIF with a named range
[SOLVED] Problem with if formula
[SOLVED] List Manager Trouble
[SOLVED] Excel Creates Formulas for You?
Vlookup on multiple sheets based on date
Sum(if()) with multiple parameters
Copy row to new sheet based on date
[SOLVED] If Integer function
linking data between worksheets
Directory type format for printing
[SOLVED] Search a column for a given cell.
[SOLVED] Formula needed that changes according to a specific day
Count number of instances
Vlookup question
corresponding dates/rows on worksheets must not have same names in them
[SOLVED] Excel 2007 - 3 Logical Tests?
Calculating simple average and stdev
[SOLVED] Count if Formula
[SOLVED] Cell format issue
modification with figuring stats
IF Parameters
IF Statement - Change font colour?
[SOLVED] IF Statement help