Excel Worksheet Functions [Archive]

Lookup - large data multiple columns?
comparing binary sequences in Excel
Integrate (Indirect(address))
SumIf & Return Specific Values
Logical Function Help
[SOLVED] problem finding the median
Simple function I am unfamiliar With.
Find double numbers function...
Counting special characters inside a cell.
transferring code between workbooks
Linked cells changing when entering lines
Comission Calculator Formula problem
Help on an array using MIN function
Needing to move resutls from one sheet to another
Function for Multiple Variables
PreText for a cell?
Excel workbook named formula problem
How to Sort witha Partial Text Match?
Capacity Calculation
Auto Sort Alphabetically
Hyperlink to specific text in another worksheet
STILL NEED HELP - formula to return data from previous column
[SOLVED] Function not getting the correct answer
Character limit?
If & calculation formulas needed
split info in a cell to different cells.
Excel Homework trouble: IF function
Excel worksheet formula returning nothing
index/match lookup - with If statements
Reading the next name down
I get error in VLOOKUP
if functions and circular references
Unsure how to properly execute tricky if function
Add "if blank" to a Formula
Automatically resorting adjusted data
Basically swap first two columns of table
Year function to get age but...
Football Predictions
Cell for user input or else function?
Copy or print list from drop down filter
Sorting data into 10% bins
IF using words and average
xlsx file, how to open
Excel Formula for Creating a Dependent Cell
Adding in a ADD statement
Matching words from two different worksheet
Random Time Generator
Complex counting time function
average question
Formula to calculate which day its weekend
[SOLVED] Formula to extract data from database
If function
Looping Columns & conditional text
Average of last 5 cells with data in them.
I want to show only weekdays on sheet
[SOLVED] Error counting words in cell when there are zero
Rank visible cells with autofilter
CASE-type function in Excel?
hourly rate and overtime factor?!
could anybody help me? :)
[SOLVED] Compute the FuTure Date when Start Date,Lead Date,Weekly Offs,Leaves and Holidays..!
Goal Seek
IF Than
Ranking scores/names from multiple sheets on summary page
Using INDEX with named range reference
Count in a range too high....
Extra to previous thread by spitinyari
[SOLVED] Troubleshooting Sumproduct and Countif formula
function to search and replace
drag formula and skip blanks rows
VLOOKUP Return Horizontal Cell, Then Move Down Rows
Vlookup on Multiple Worksheets
Calculating needed responses
[SOLVED] Vlookup to access data based on a drop-down list
formula with arrays
Workbook with muliple sheets
[SOLVED] If / concatenate
[SOLVED] using a vlookup and returning a cell reference
[SOLVED] Adding ever extending data based on conditions
SUMIF 2 conditions are met
Time duration
funtion argument
Lock cells so content or formula can't be changed
IF then funtion for 2 conditions
VLOOKUP Changes Itself
[SOLVED] Vlookup
How to do this? Copy rows down based on number...
glass pricing sheet, matching an m2 area to a price range
[SOLVED] Take Two Columns and merge them without losing data
Changing cell values depending on drop down selection
[SOLVED] Using conditional formatting to find the respective remarks
[SOLVED] Display negative time?
How to count unpaid installments.
Advanced Filtering question
autofilter/comment problem
Conditionally adding a border to a range of cells
IF forumla needs revision.
Malfunctioning SUMIF function???
excel function help
Inventory Running Balance
[SOLVED] Formula for Both Base and OT Wages
1st of the month!
Need help with organizational formulas
search and match an unsorted list
[SOLVED] How to format numbers into amounts
[SOLVED] Modify NETWORKINGDAYS
Delete specfic word
delete a selective word
Ceiling levels to a round figure
[SOLVED] Conditionally collect data in one cell?
cross sheet lookup issues
[SOLVED] SUMPRODUCT combined with other functions
formual to deduct vat
Dependent counting
Trying to take an average of numbers in specific cells...
[SOLVED] Lookup from another sheet
Formula to compare data in different pivot tables?
split data in a cell
[SOLVED] Function inside textstring
[SOLVED] Index/Lookup formula
Coping specific rolls of a sheet to a specific rolls in another sheet
Is there a function to link a cell to a fomula?
[SOLVED] Pushing data across column when new data it entered.
Another IF statement nesting problem
Linking 2 spreadsheets without using vlookup or range lookup
sql.connect
Multiple correct in data validation drop down box
[SOLVED] hyperlink mailto function, need to take body text from cell
How can i shorten my formula
Put 2 IF STATEMENTs together
Formula?
[SOLVED] Lookup Formula with two lookup values
[SOLVED] If Statement based on validation list
[SOLVED] Count number of dates older than 30 days
Sumif across columns
Selecting specific cell if score falls within specific range
Average? sub Average?
[SOLVED] Match and Index
Concatenating columns
Replacing Subproduct - Slow Calculation
Formula to copy some rolls to specific rows in another worksheet
Find and Add data
Separating Text & numbres
[SOLVED] Worksheet search display problem
[SOLVED] Problem with OFFSET function used in Named Ranges
[SOLVED] Summing decimal time entries
[SOLVED] Count number of entries in a Sheet
Problems using Date in Advanced Filter
[SOLVED] ISNUMBER problem
array or match - I'm confused!
Cell pattern in function
calculate end date using start date and number of specific weekdays
Building a comma delimited string from Cell Range
How to sum accounts and subaccount
[SOLVED] Calculate prices using values entered by size
[SOLVED] Work around to the 7 function limit with the IF function
[SOLVED] sum for mutiple returns - formula needed. sumif?
[SOLVED] Value Pulled Per List Drop Down selection
Multiple "IF" commands with different formulas calling from a Table.
Populating a table from Pivot data
Linking worksheets using common data
Remove duplicates issue
[SOLVED] Display the top 5 values withinin a range on a different row.
[SOLVED] Non-nested IF Function?...
[SOLVED] IF Statement
[SOLVED] Looking for a counting formula...
[SOLVED] Lookup or match
picking up figures
INDEX, MATCH Multiple Values
[SOLVED] Total number of unique matches in two columns
offset function
Little programme for company
[SOLVED] Find/Replace (Selection only)
[SOLVED] lookup values in two different sheets
[SOLVED] Preventing Cell Reference Deletion
Average formula for non-hidden rows only
Basic VLookup function doesn't work in large data set from msquery
Subtracting Date/Time w/ Criteria
Search (match) through columns and find ALL matches
[SOLVED] Using Named functions = Error. (#VALUE!)
Automatically add data by quarter
[SOLVED] Summing totals through IF function...
[SOLVED] Filtering a LONG list to entries in a shorter list
[SOLVED] Using Lookup function in a larger formula
[SOLVED] Difference between two times - thank you!!
How do I return the next lowest value in an array?
[SOLVED] Counting multiple conditions
[SOLVED] merge 2 named ranges
New Sheet Add, Sheet visible & Menu disable problem
[SOLVED] Lookup across various sheets
vlookup for date values
[SOLVED] Conditional formatting across worksheets
Columns with the most similar data
To give a solution in another cell
Generating a Leaves Table in the specified format.
Unique values in a column with duplicates
[SOLVED] Matching and Sorting Non-Identical Row Pairs
After copying sheet I get this message?
[SOLVED] Conditional Formating - Adding & Deleting Rows
how to organise this into spreadsheet?
[SOLVED] finding or matching data
[SOLVED] Find Data that matches query
IF AND OR Complications...
[SOLVED] Display the value of a cell
[SOLVED] SUMPRODUCT to accurately calculate tiered sequential pricing.
type in values in column A and then just print the rows that have a value in column A
[SOLVED] customer records data sheet
IF statement
[SOLVED] Can we use two ranges in Networkday Function?
[SOLVED] Placing the date (1-JAN-2008) in the right column for DAY
merging data from two cells
[SOLVED] Formatting Cells From Another Cell
Flagging Duplicates based on Multiple conditions
[SOLVED] To get the Alphabetic Name for a Column No
Mround function
If statment on cell with fractions
split the phone number and email id into two different columns....
[SOLVED] Excel Can't Multiply...why is simple multiplication incorrect?
[SOLVED] Can you Track the date a different field was updated?
counting changes made today
[SOLVED] Counting multiple text conditions
DMEDIAN or DMODE ??
ctrl-shift-enter problem transpose
Vlookup & offset?
Vlookup to different workbooks
Vlookup - Dynamic Columns
Combining few columns logically
atMerged cells not allowing Index Mch function to give value
Forumla for creating yearly event calendar
Multiple Criteria Data Filtering
Using Index and Match to organize by rank
Word count
Simple question regarding IF statements
[SOLVED] IF FUNCTION (maybe)
countif and multiple named ranges
[SOLVED] Using vlookup to get a sales volume but need to meet 2 criterias
comparing values in two sheets of same workbook
Formula - poss countif and sum
AVERAGEIF Function in Excel 2003
[SOLVED] IF/THEN Statement with Calculation
Multiple Part Cells?
using x as cell number hard to explain
IF + ROUNDUP hierarchy
I need a warning message!
Formula to return Unique Entries Only
Sumproduct help!
[SOLVED] Formula not Calculating Except After Using Text to Columns
24 hour time to change date
Put colums with data together
Copy rows to new sheet if value of cell entered greater than 1