Excel Worksheet Functions - Page 5

Thread / Thread Starter	Last Post	Replies	Views
How to return multiple cells from a data sheet in a seperate workbook [email protected]	by [email protected]	19	1,329
Calculating of time H. Nissen	by H. Nissen[_2_]	18	1,392
Vlookup won't work mkcma	by xlmate via OfficeKB.com	18	1,759
Custom Number jal111	by [email protected]	18	4,839
VLOOKUP Connie Martin	by Jack	18	1,219
How to create filter using criteria from other cells. JLewis	by Peo Sjoblom	18	1,116
Formula for Dates Daren	by ShaneDevenshire	18	990
Date range lookup....tough one! deeds	by deeds	18	958
Need (Excel) formula to make Mark sheet with Automatic Grading Need Formula for Mark Sheet	by ExcelBanter AI	18	17,863
Using an Excel sheet for batch delete Colin Hayes	by pgarcia	18	1,800
Counting number of pay period dates between 2 numbers janplan	by ExcelBanter AI	18	8,048
Some kind of Array-Sumproduct Function ryguy7272	by Max	18	1,009
Find position of first non-matching character Greg Lovern	by Harlan Grove[_2_]	18	1,452
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!! forevertrying	by Scarlett	18	1,824
sum a value depending on the value of a cell?? UKMAN	by RagDyeR	18	973
Understanding SUMPRODUCT() Jakobshavn Isbrae	by Bob Phillips	18	965
Interpolate in table lookup proinwv	by ExcelBanter AI	18	14,255
If statement [email protected]	by TRYING	18	854
create a formula to produce a color in excel Senie	by Spike9458	18	1,791
Spell Check in Text Boxes Lee Ann[_2_]	by Lee Ann[_2_]	18	3,139
sum cells with specific text in comments phillip cole	by Claus Busch	18	3,624
Copy values for every nth cell dpgreen	by dpgreen	18	2,313
Lock Cell After Data is Entered on Particular Cell Moideen	by [email protected]	18	6,393
date and time difference Stumped	by Stumped	18	1,163
Find and Return the Non-Blank entry Art	by T. Valko	18	1,005
If (Vlookup 0) working, but what if Vlookup cell does not exist Steve	by Steve	18	2,700
Combining Data from 2 worksheets gmoore	by Max	18	1,078
Simple - F9, then K9, then, P9, then U9, etc... Steve	by T. Valko	18	1,048
Naming Worksheet Tabs? Scoober	by Jacob Skaria	18	1,395
How to extract text from middle of a string Makelei	by Ron Rosenfeld	18	5,792
Dates and If Function Ginger	by Ron Rosenfeld	18	986
Check for a word Kashyap	by Glenn	18	934
Copying a column list from one sheet to another and repeating??? simon	by simon	18	876
Displaying items from a column list in another sheet? pieman3	by simon	18	812
Matching data in two columns Max	by T. Valko	18	871
Pick Ref# randomly on an average Kashyap	by Max	18	1,091
Test 2 numbers Dave	by Shane Devenshire[_2_]	18	1,042
Excel crashes when typing "false" in VLookup function pcbins	by Glenn	18	1,545
Unique identifier Steve Barnett	by Steve Barnett	18	1,503
Need help implementing EPA rounding method Will S.	by plb2882	18	2,709
using nested OR stef	by stef	18	1,235
Formula For Summarizing Data Tiziano	by Max	18	1,043
How do I count frequency based on 2 criteria (including month) RS	by RS	18	1,882
Delete the number "49" from each cell in a column se12	by Gord Dibben	18	1,500
Negative numbers in an IF formula TammyS	by TammyS	18	1,320
if function bronking	by daddylonglegs	18	901
Letters and Number formulas 2pojeff	by Ken Johnson	18	1,593
vlookup formula not working with data on separate sheet akee	by Cutter	18	2,014
Help with SumIf Raj	by Pete_UK	18	956
Reference Previous Sheet [email protected]	by Harlan Grove	18	1,815
Sumproduct and wildcards vipa2000	by Domenic	18	1,480
Max date Maxi	by Maxi	18	910
Extract last and next-to-last entries in a range Teri	by Biff	18	1,169
Why help? infoman	by GeorgeF	18	889
Up Arrows / Down Arrows MWH	by Norman Jones	18	1,499
Numbers Converted to Text - Last Digit Replaced by Zero Cheryl B.	by Ron Rosenfeld	18	2,367
Strip carriage return, add row adin	by Bob Phillips	18	1,919
Count Unique Text Values Scott Halper	by Domenic	18	2,232
PULL FUNCTION Sandyl	by Sandy	18	2,041
IF, AND, BUT and ON-THE-OTHER-HAND formula :) JockW	by JockW	18	1,011
Investing,Mutual Funds Formula? Crackles McFarly	by joeu2004	18	2,047
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,070
formula for separating parts of cells Jamie	by confused!!	18	1,231
Can Someone tell me why this won't work????????????? skijsh1979	by skijsh1979	18	802
How to repeat one cell specific times to form an array? liups	by T. Valko	18	1,116
How to: Find first empty cell in column DW	by DW	18	2,781
Sharing info across 2 workbooks S Willingham	by S Willingham	18	1,211
How to count the odd or even in an excel area? Bill.liu	by Epinn	18	1,107
need help with a formula Rhonda Edwards	by Pete_UK	18	1,418
ARRAY?, CONSTANT?, INDIRECT?, CONSTITUATE? SayWhatAuto	by SayWhatAuto	18	1,400
Data Validation - Dependent Lists & Conditional Formatting Bob	by Gord Dibben	18	2,107
How to copy workbook? LF	by macropod	18	1,090
Average of values in row excluding the highest and lowest value? frosterrj	by Biff	18	3,024
Referencing last cell Jean	by Alan	17	1,361