Excel Worksheet Functions [Archive]

Get a sum total based on three criteria
vlookup question
Addition/Subtraction with Menu Selection
Locking particular objects - excel 2007
Dependant Value Return - Employee Database
[SOLVED] help with IF rules
Making references?
Indirect adn sort
[SOLVED] Pigeon-holing rows of information
Name sheets in a macro
vlookup - Show Duplicates
Countif or VBA based on cell color
[SOLVED] More Drop Down Menu Help!
[SOLVED] How to match 2 criterias in an array?
[SOLVED] vlookup wont work with the text ax??
Add text to a drop down list
Compare 2 cell values then display dialog box
[SOLVED] Drop Down Menu Values
Stumped with Date function
worksheet function to assign value to cell
compile data from multiple worksheets into one worksheet
Programming information from one sheet for another sheet - Mechanic Daily Worksheet
lookup function for 2 criteria?
macros to clean, summarize, and merge reaction time data files?
shorter "if" statement
[SOLVED] To VLOOKUP or not to VLOOKUP?!?
Using the IF Function ????
Find Minimum, excluding ties
[SOLVED] formula at the top of the sheet to show the latest figure in column
Can I use a If formula or another one?
remove heading from multi-page report
[SOLVED] COUNT or FREQUENCY with multiple criteria
Delete Rows based on content
Moving multiple folders and files to different location
Empty first column disappears on "save"
[SOLVED] Need formula to check adjacent cell value, and report.
Autofit and default row height
If statement problem
[SOLVED] How can I copy desired cell content ?
formula for counting cells within a given range
How do I put quotation marks ("") in an IF/THEN Function
[SOLVED] Conditional IF/THEN question
Formula Rq'd to read range and value
[SOLVED] "Dynamic Named Range" in VLOOKUP
highlighting duplicate cells
Sumproduct, Rows and Columns
[SOLVED] adding a new item to a named range option
[SOLVED] Finding a match in different columns
[SOLVED] Countif different columns
Creating a Sum of Data based on Job # Being Criteria.
IF Statement
[SOLVED] Cell protection macro
[SOLVED] using Functions to Code Overtime Calculations having to do with time in excess of 40h
VLOOKUP question
[SOLVED] Extracting a continuous list based on criteria
Summing using multiple conditions
[SOLVED] INDEX/MATCH with no match
Lookup Unique based on Multiple Conditions
[SOLVED] Help with LOOKUP / MATCH Function
[SOLVED] TODAY() function to text
[SOLVED] Excel cant count or I am crazy!
Using IF to assign text/cell color
selecting cells based on other cell values
[SOLVED] Calculating working days for multiple people
Ignore two lowest numbers in a range
Link tab name to a cell
[SOLVED] why is this formula not working??
excel dates etc
time formula with fixed travel time
match/lookup formulas
[SOLVED] If formula help (maybe it's if)
[SOLVED] If statement Problem
[SOLVED] Confused with VLOOKUP
Summing across worksheets
[SOLVED] #ref! error needs to be 0
Cell Always upper case regardless of input
[SOLVED] count if the Interior color of cells is blue
move cursor from to cell B after click on cell A
File size problems
Vlookup functions
Multi Conditioned Lookup
ROW number corresponding to a data
Date, Time calculation
flie modification date
[SOLVED] Count Unique Values in a Filtered Column
Functions and Pivot Tables
Using Sumproducts with dynamic data
[SOLVED] IF statement to read text in a cell
Indirect problem
Reverse the code
Excel Function (need a Like function)
[SOLVED] vlookup + array formula producing #Value!
database query to list certain items
[SOLVED] Mark repeating field
Assign a produce a number
Automatically Format Cell Borders
[SOLVED] transfer data from one sheet to another with formula
[SOLVED] Help with IF and OR statement
vlookup updating question
[SOLVED] Mail Merge in Excel
Conditional formula trouble
Hiding Leap Year Row
[SOLVED] nesting OR, AND within IF - Solved
[SOLVED] Deleting entire customer entry if one cell is blank?
[SOLVED] Indirect()
formula help
to the min formula
[SOLVED] Help Searching Text List and Calculating Values
Using XIRR formula
removing symbols from a cell without rounding numbers
Conditional Formatting 2
[SOLVED] Can vlookup two columns instead of one?
[SOLVED] =IF caps at 8 arguments?
Conditional formatting a percentage
[SOLVED] Identify duplicates across multiple colums and rows
3 Way If formula & Advice needed on what book to buy
extract date from cell with other strings
[SOLVED] Using Cell Values to Populate with Characters?
[SOLVED] Problem with Search formula
[SOLVED] show unique values from two or more columns
Heres what i need
[SOLVED] COUNTIF: dynamic range
[SOLVED] sort ascending with formula
Auto Populate Dates
Vlookup
Year-to-date
What does this mean in plain english?
[SOLVED] IF function
Search function
Playing a Sound Based on a Cell's Value
Need Help on Excel Function for List
Need If function solution for a price sheet!!!
Combining a max and if function?
remove #value error
Change size of one cell
[SOLVED] display end time automatically upon entering start time and time usage
Making a form
[SOLVED] Countif Help!?
Conditional data validation
[SOLVED] ? Auto duplicate row contents from 1 sheet to 2nd sheet if column contains set words
#N/A error in sheet - how to hide ?
[SOLVED] "changing pricelist"
Need Help Urgent Please !!!
Plotting with Conditional Formatting
[SOLVED] unique value in a column
Seperating hh:mm:ss
[SOLVED] count number of element
Conditional Formating with Text
Lookup Names
Fill Handle to increment sheet numbers
[SOLVED] Todate Sum formula
[SOLVED] "Lastname, Firstname" to "Professor Lastname"
Remove duplicates, filter by smallest value
Tracing Precedents to Other WorkBooks
IF statement
IF statment with numbers vs. text
find string in array with similar data
Clear button
I need a function similar to SUMPRODUCT
Info/Formulas from Sheet to Sheet
Counting Days in a Date Column
calculating the # of days btwn 2 dates INCLUDING the dates
[SOLVED] Need cell value to be worksheet name
Timesheet Calculator
[SOLVED] Payment date
box and whisker plots
Funds Transfer Formula
Deleting cells depending on content of another cell
Dynamic VLookUp
Autopopulating data based on list selection
[SOLVED] Vlookup help
Check if a number of cells are equal
Reduce File Size
extracting email addresses from cells
Help with formulas
Nested if problem
[SOLVED] Summing multiple calculations
[SOLVED] LOOKUP #N/A error
Can Excel split an entry into seperate cells?
[SOLVED] convert cell address to corresponding cell
Altering the point from which VLOOKUP begins searching
Formula for Calculations for extra Payment
[SOLVED] Cell Data Separation Question
[SOLVED] Trying to imitate AVERAGEIF() with an OR() test.
Totals not coming out correct.
[SOLVED] Return multiple Occurrences on same row
Fiscal months
Using Offset while calculating YTD for a Fiscal Year
[SOLVED] Search and return a value
Vlookup help
[SOLVED] Adding 7 working days to a date
Count # of times a worksheet is printed
ALT + DOWN function seems missing on new Excel
Calculate cotangent (cotan)
[SOLVED] Relevant Quarter
formula for displaying a cell when another is populated
Copy fields from sheet to sheet only if not empty and only on-demand
[SOLVED] CHAR(255) Not picking up the letter "Y"
[SOLVED] "Time" problem: Need function to find time&date - ?hours
[SOLVED] irr formula for investment
Excluding Numerical Characters Based on Criteria
Derive 25,000 data out of 500 existing data using T- Distribution
[SOLVED] Nested IF(SEARCH)
[SOLVED] conditional format according to day
[SOLVED] conditional format according to day
[SOLVED] Sorting percentages in descending order
breaking text in a cell into two or more cells
[SOLVED] Count If
Date Comparison
hiding cells that are null
[SOLVED] Count valid phone numbers and email addresses
sum up two cells when one of them has an if function?
VLookup - find highest Value...
If-Then function from one worksheet to another
[SOLVED] Counting Without Returning 0...
Counting
How to get a Numeric result from text input
[SOLVED] Extract number from alphanumeric string
Count formula - multiple criteria
[SOLVED] OR Function Confusion
Counting items for differnt sales groups by length of time.
[SOLVED] Automated Target dates based on Priority Rating
count function????
Merging two Excel files
Formula to work out pay rate with multiple conditions
[SOLVED] if function
[SOLVED] Sort List based on Permutation
[SOLVED] How to move or remove negative entries in a range?
Summation of n
[SOLVED] Dates, Number of Years
Return the reference of a reference
Multiple criteria contains text
[SOLVED] Return the Last Occurrence of a Number in Range
[SOLVED] determining a set value from multiple ranges?
[SOLVED] Counting month and year from a date column
[SOLVED] Counting text, but not formulas
Formula insanity..
If a character is present, then move entire cell to...
IRR based on a value range length that changes.
max turns to #N/A when some argument cells contain #N/A
Conditional Formatting based on a drop down list
[SOLVED] Copying data from different files into a new file
Duty Roster
[SOLVED] Conditional formating gone crazy, Help!!
[SOLVED] dsum on multiple criteria
Concatenation of Rows
[SOLVED] if command
Variable Data from a Pull Down Menu
Automatic assingment of cell values after comparison of two worksheets.
Using sumif to look up 2 criteria