Excel Worksheet Functions [Archive] - Page 3

[SOLVED] deleting spaces/merge question
SUMIF Multiple Criteria or SUMPRODUCT?
[SOLVED] Grouping and averaging
get value from other worksheet
dependant combobox in every cell of the column
IF Statement
[SOLVED] Linking cells by looking up part of link in other cells
[SOLVED] Vlookup comparing 2 text lists
[SOLVED] Counting if conditions are met
conditional formatting/days of the week
Orders Per Week
Linking spreadsheets
[SOLVED] Indexing/Match problem
[SOLVED] Last active cell in a column
Finding certain values from 2 columns and merging them into 1 cell
[SOLVED] Automatically fill cell value based on another cell
[SOLVED] Separating TEXT into different columns
Dynamic cells
Averageif And #div/0 problem
[SOLVED] Formula to Calculate speed knowing distance, destination time and checkpoint times
[SOLVED] Inserting commas into cells with mailing addresses
Sumif in 3 rows
Any ideas?
[SOLVED] How to retrieve second to last letter of a string
IF Statement + adding
Multiple IF statement
IF formula question...
Simple Data Entry Problem
Dynamic range with formula
count the values in each cell of Column B but only the cells that have a value of 15
How to get live updates from the Net?
How to get live updates from the Net?
Date Reference
Linking To Another File
Cell Value lookup
Need help creating a formula
[SOLVED] Conditional Formatting with IF/Then Statements
[SOLVED] Retrieve Values from a List
Simple Cell Reference question
[SOLVED] Shorter If statement
Show nothing in a cell with no value
Matching two colums with two constraints
Function to delete specific rows
Rounding function works on 1 PC but not another.
[SOLVED] Birthday indicator formula
[SOLVED] "MAXIF" Function, or equivalent?
Delete Specific Rows/Columns
Help! How to duplicate (autofill) cell contents to other worksheets!
[SOLVED] Apply conditional formatting to a cell when it is left BLANK
How do I get excel to use the value shown and not the hard value in math.
Calculate according to conditions
[SOLVED] Make vlookup move on from an empty cell?
Conditional logic across 3 columns??
selecting a formula with a selection box
Adding with Condition
Compare values across 3 columns
VLookup with ranges
Intercept and Linest functions.
product sum function
Find Largest Submatrix
Returning values from a list including blanks
lookup
Average multiple rows based on 2 columns
previous days in a formula
[SOLVED] Copy a formula several times, changing its value
[SOLVED] How to calculate max profit per quarter ?
[SOLVED] Formula for schedule
[SOLVED] Combine IF conditions
Need a function to figure interest rate.
Hyperlink to the Worksheet level
Import .txt and run macro
[SOLVED] Format TODAY() within a CONCATENATE formula
VBA Conditional Formatting Based on Formula True
Calculating timesheet using IF Function?
COUNTIF with some Logical functions Query
count number of instances of string in a string
Fill Series
Computing Days in a month
Stock Portfolio Analysis
[SOLVED] Changing a Table layout
[SOLVED] Creating a 2-dimensional array from a 1-dimensional list
If statement to play macro
find and copy
text to a unique number
Return No. of hrs from Times ?
Rounding question
printing s/sheet with grid for reference
Returning Lookup Results Based on 3 Criteria
Vlookup not finding all the matches
Changing calendar based on year with static days
Can a positive number be converted into a negative number?
[SOLVED] Vlookup in combine with an Array Formula
How Do u get a piner to work
[SOLVED] Conditional formatting and differing time scales
Generating a 1st,2nd,3rd number series
Advance Filter
Transpose in bulk
Hours Calculation
Using conditional formatting with vlookup
[SOLVED] Extract 1st matching substring from cell
[SOLVED] Must find the largest value within a formula
Does Vlookup and Match functions work for this requirement
Extended IF Formula
[SOLVED] Copying from one sheet to another
Sumproduct
[SOLVED] How To Find SUM of Parts of a Colum that relate to the info in the column beside...
[SOLVED] nested countif not working
[SOLVED] rounding with three options
What to research??
[SOLVED] Vlookup Help
[SOLVED] How to average without counting any zero's
Locking formulae in a cell
Sumif for a given year
Difficult question about simple task (If, Vlookup)
Counting hourly occurences between start and finish times
3d reference question
[SOLVED] Nested IF function
[SOLVED] Comparing criteria across columns
[SOLVED] formula for smallest
[SOLVED] Table Array - Data Lookup
Rounding up to nearest half
[SOLVED] Find and return part of a date
INDEX, MATCH the INDEX?
Adding a suffix to a cell
[SOLVED] Table array
[SOLVED] Can't Lookup with array
Stock Cost Average
Simple WorkSheetFunction
[SOLVED] Excel 2003: COUNTIF/SUMPRODUCT, Multiple Criteria w/Wildcard
Returning Multiple Matches from a range
[SOLVED] Need Formula to convert Minutes into hh:mm:ss
[SOLVED] Check font color and return a True or False
[SOLVED] Referencing a row of cells in a column
[SOLVED] Seperating Data into 2 different zones on 2 different sheets
[SOLVED] Adding Date and Time fields
Find avergae between cells.
Disabling a cell
"Merge cells" changes values
Formula for making Text Proper worked - but how do I transpose it to correct column?
VLOOKUP Help?
Show Day & Date For Week
[SOLVED] Date ranges intersection
Maximum function but excluding error values
look for value in matrix, return values from kolumns corresponding rows where value..
Designing a Random Seating Arrangement
[SOLVED] IF-THEN function for many conditions
[SOLVED] Next name down a list
Limitations when Combining OFFSET and MATCH to return a cell reference
Drop down menu problem
vlookup with mutiple matching rows
auto changing text
Multiple IF Statements
Selecting specific numbers from a column
Need help with totalling prices.
[SOLVED] formula to find distance across points on a grid
IF function question
return cell references based on criteria
Truncate TEXT to coulmn
Referencing a data table and returning a value
Pasting a function does nothing
Find lowest number in groups then lowest overall.
OR logic with AVERAGEIFS
[SOLVED] Adding text values and date values to get a single-digit answer
[SOLVED] Combine two columns from different worksheets
Average of last 5 cells in a series.
Remember Previous Result IF Link Not Avail.
Display Expense used up in user defined date range
Conditional formatting column
Evaluate String using function
Function Help
[SOLVED] Can we use forumula as criteria for sumifs?
School hours formula for a cell phone bill
[SOLVED] compare matching values
[SOLVED] Rounding $ within an IF function
Counting consecutive blank cells?
[SOLVED] Find numerical difference between text values.
[SOLVED] Sum 1 or more items in a cell
Waterfall Cash Model, dividing up cash flows based on IRR
[SOLVED] ISERROR at end of IF Statement
Sorting information
Transferring selected Data from one column to another
[SOLVED] more digits from polynomial regressions?
If Statement Formula Result Needed
Counting only cells in a row that have data in them.
Checking for duplicate numbers in a list
Display Values of Column/Range/Array/Other
=Status!A2
[SOLVED] count formula
[SOLVED] LOOKUP Function
[SOLVED] Find closes possible value in cell array
VLOOKUP With CONCATENATE and IF?
IF AND Functions..Again
INDIRECT.EXT to build a range in VLOOKUP
Filter highlighted rows
Sum of values for a date column monthwise
When in TABLE mode, how to auto-copy formula when creating new entry ?
Formula calculate no carry over
How do I add workdays to a date?
[SOLVED] Retrieving data from table
Alphabetizing worksheets????
Averaging a section of a field of numbers
[SOLVED] Adding one if there is data in adjacent columns
transposing
Complex Filtering with Multiple Criteria
Formula Help!!!
IF Function problems
[SOLVED] RC[-1] formula question
read only with no option to resave
Another match and replace problem
[SOLVED] Referencing to cells next to a given cell?
vlookup help
[SOLVED] Automatically adding new worsheets to existing sums
[SOLVED] UK Postcode Solutions MID LEFT Functions
Lookup using condition
Find hightest/lowest frequency's...
pull a value from a range
[SOLVED] Data match function
Dynamic Data Validation
Check for duplicates but allow some
Fast way to check if column contains duplicates
Spot the difference
Multiple Criteria for sumif
Importing AUS stock prices
Advanced Concatenate
Displaying true or false if a cell is the lowest value
MATCHing 4 columns to each other
If Statement from 2 worksheets
[SOLVED] Lookup 2 values to return 1 value
[SOLVED] vlookup and match to sum all else except certain cells
[SOLVED] or exact = true
workbook reference in cell reference: as clearly as i can be...
worksheet reference: as clearly as i can be...
[SOLVED] Limiting number of items in a range from a list
[SOLVED] Fixed width with CONCATENATE
Matching multiple columns
Adding cells that fit criteria
Complicated lookup formula
Excel excel functions
[SOLVED] Show zero if amount is a minus
[SOLVED] Conditional Formating
[SOLVED] unknown cell refernce in formula
Display COUNTIF results in reverse order
[SOLVED] lookfunction
Build a organized data sheet from another sheet
Vlookup to retreive data for multiple rows
Count the instances of more than one value in a given range
[SOLVED] Lookup - large data multiple columns?
[SOLVED] comparing binary sequences in Excel
[SOLVED]Integrate (Indirect(address))
SumIf & Return Specific Values