Excel Worksheet Functions - Page 5

Thread / Thread Starter	Last Post	Replies	Views
IF ISERROR INDIRECT MATCH Formula Question??? grateful	by grateful	19	1,669
sum cells with specific text in comments phillip cole	by Claus Busch	18	3,582
Vlookup won't work mkcma	by xlmate via OfficeKB.com	18	1,743
Custom Number jal111	by [email protected]	18	4,809
VLOOKUP Connie Martin	by Jack	18	1,217
How to create filter using criteria from other cells. JLewis	by Peo Sjoblom	18	1,109
Formula for Dates Daren	by ShaneDevenshire	18	987
Date range lookup....tough one! deeds	by deeds	18	950
Need (Excel) formula to make Mark sheet with Automatic Grading Need Formula for Mark Sheet	by ExcelBanter AI	18	17,820
Using an Excel sheet for batch delete Colin Hayes	by pgarcia	18	1,788
Counting number of pay period dates between 2 numbers janplan	by ExcelBanter AI	18	8,039
Calculating of time H. Nissen	by H. Nissen[_2_]	18	1,388
Find position of first non-matching character Greg Lovern	by Harlan Grove[_2_]	18	1,447
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!! forevertrying	by Scarlett	18	1,813
sum a value depending on the value of a cell?? UKMAN	by RagDyeR	18	967
Understanding SUMPRODUCT() Jakobshavn Isbrae	by Bob Phillips	18	960
Interpolate in table lookup proinwv	by ExcelBanter AI	18	14,214
If statement [email protected]	by TRYING	18	853
Some kind of Array-Sumproduct Function ryguy7272	by Max	18	1,008
Excel crashes when typing "false" in VLookup function pcbins	by Glenn	18	1,536
Copy values for every nth cell dpgreen	by dpgreen	18	2,309
Lock Cell After Data is Entered on Particular Cell Moideen	by [email protected]	18	6,261
date and time difference Stumped	by Stumped	18	1,158
Find and Return the Non-Blank entry Art	by T. Valko	18	997
If (Vlookup 0) working, but what if Vlookup cell does not exist Steve	by Steve	18	2,663
Combining Data from 2 worksheets gmoore	by Max	18	1,075
Simple - F9, then K9, then, P9, then U9, etc... Steve	by T. Valko	18	1,044
Test 2 numbers Dave	by Shane Devenshire[_2_]	18	1,039
Naming Worksheet Tabs? Scoober	by Jacob Skaria	18	1,386
Spell Check in Text Boxes Lee Ann[_2_]	by Lee Ann[_2_]	18	3,133
Dates and If Function Ginger	by Ron Rosenfeld	18	981
Check for a word Kashyap	by Glenn	18	928
Copying a column list from one sheet to another and repeating??? simon	by simon	18	871
Displaying items from a column list in another sheet? pieman3	by simon	18	808
Matching data in two columns Max	by T. Valko	18	870
Pick Ref# randomly on an average Kashyap	by Max	18	1,085
create a formula to produce a color in excel Senie	by Spike9458	18	1,786
How to: Find first empty cell in column DW	by DW	18	2,768
Formula For Summarizing Data Tiziano	by Max	18	1,041
How do I count frequency based on 2 criteria (including month) RS	by RS	18	1,872
Delete the number "49" from each cell in a column se12	by Gord Dibben	18	1,493
Negative numbers in an IF formula TammyS	by TammyS	18	1,316
if function bronking	by daddylonglegs	18	894
Letters and Number formulas 2pojeff	by Ken Johnson	18	1,585
vlookup formula not working with data on separate sheet akee	by Cutter	18	2,000
Unique identifier Steve Barnett	by Steve Barnett	18	1,491
Reference Previous Sheet [email protected]	by Harlan Grove	18	1,809
Sumproduct and wildcards vipa2000	by Domenic	18	1,470
Max date Maxi	by Maxi	18	905
Extract last and next-to-last entries in a range Teri	by Biff	18	1,165
Why help? infoman	by GeorgeF	18	883
Up Arrows / Down Arrows MWH	by Norman Jones	18	1,490
Numbers Converted to Text - Last Digit Replaced by Zero Cheryl B.	by Ron Rosenfeld	18	2,353
Strip carriage return, add row adin	by Bob Phillips	18	1,907
using nested OR stef	by stef	18	1,227
Need help implementing EPA rounding method Will S.	by plb2882	18	2,662
Help with SumIf Raj	by Pete_UK	18	948
How to extract text from middle of a string Makelei	by Ron Rosenfeld	18	5,783
IF, AND, BUT and ON-THE-OTHER-HAND formula :) JockW	by JockW	18	1,009
Investing,Mutual Funds Formula? Crackles McFarly	by joeu2004	18	2,038
How do I ask a cell to look only at the first character in a cell soconfused	by Toppers	18	1,048
Multiple "lookup_value" Noel	by Sandy Mann	18	1,061
formula for separating parts of cells Jamie	by confused!!	18	1,223
Can Someone tell me why this won't work????????????? skijsh1979	by skijsh1979	18	797
How to repeat one cell specific times to form an array? liups	by T. Valko	18	1,110
Count Unique Text Values Scott Halper	by Domenic	18	2,227
Average of values in row excluding the highest and lowest value? frosterrj	by Biff	18	3,017
How to copy workbook? LF	by macropod	18	1,077
Data Validation - Dependent Lists & Conditional Formatting Bob	by Gord Dibben	18	2,098
ARRAY?, CONSTANT?, INDIRECT?, CONSTITUATE? SayWhatAuto	by SayWhatAuto	18	1,396
need help with a formula Rhonda Edwards	by Pete_UK	18	1,415
How to count the odd or even in an excel area? Bill.liu	by Epinn	18	1,104
Sharing info across 2 workbooks S Willingham	by S Willingham	18	1,205
PULL FUNCTION Sandyl	by Sandy	18	2,030
How long for the first group PAL	by Bernie Deitrick	17	1,127