Excel Worksheet Functions - Page 205

Thread / Thread Starter	Last Post	Replies	Views
Simple subtraction formula returning strange results = Excel glitc Ginger	by JoeU2004	13	1,318
formula result is zero but zero is not populating in cell [email protected]	by Sheeloo[_4_]	3	806
Array formula: how to join 2 ranges together to form one array? Rich_84	by Dave Peterson	2	2,763
Rate of change Mike	by Mike	4	836
Returning to multiple data fields pivot table view ohadn77	by ohadn77	0	410
help with formulas??? Natasha	by Ross	2	314
summing 2 to 8 separate numbers in a single cell Green Fox	by Green Fox	2	1,145
Conversion help Iriemon	by OssieMac	1	402
PERCENTAGE OF VACANCY michelle wilson	by Mike H	2	733
Freeze Pane option in Vista Jen	by Je	2	404
Macro Buttons Lois	by Jacob Skaria	4	475
macro apply to all worksheet AskExcel	by Jacob Skaria	3	879
Need your help with formulas in excel!! michelle wilson	by Dave	7	364
Averaging Blank Cells John Calder	by Dave Peterson	4	533
Macro warning - how to delete macro GavinS	by Dave Peterson	3	826
How to insert $ and ‚¬ amounts in the same worksheet? Neophyte[_2_]	by Jacob Skaria	1	372
Hierarchical outlining Michael.Tarnowski	by Jacob Skaria	2	345
Sum Result of lookup in excel 2007 David Ryan	by David Ryan	5	538
Hyperlink problem Petervan	by Héctor Miguel	1	365
Timed macros LiAD	by LiAD	5	351
Recording macro usage LiAD	by LiAD	8	498
XIRR over several years Don Kline[_2_]	by JoeU2004	11	989
help with look up formula Bob Bob	by Bob Bob	5	398
Add values in "P" that fall between dates "03/01/00 and 03/31/00" Art	by macropod[_2_]	6	409
extract row number from Pivot Table Result gtslabs	by Max	1	1,257
Name Worksheet MCheru	by MCheru	6	381
Rows to columns Chris	by Chris	2	315
Formula Harish	by Harish	6	1,084
VLOOKUP & Array AlanR	by T. Valko	8	485
Need Function/Formula that will add a column based on two conditon SW[_2_]	by T. Valko	3	330
Conditional SUM Mike McLellan	by Ashish Mathur[_2_]	2	348
Grouping above in Excel 2007 SJKM	by Sheeloo[_4_]	7	1,280
add-in manager tleehh	by ryguy7272	1	587
Collapsing/expanding grouped areas on multiple pages Maxsteel	by ryguy7272	1	603
Vlookup returning NA when referencing cell data to another sheet Giacomo[_2_]	by T. Valko	3	1,424
how to sum quite a bit of duplicates into a cell bb sprgfld	by bb sprgfld[_2_]	3	498
finding a match SandyL	by SandyL	2	351
Formula won't calculate lindahamilton	by Sarge	4	350
insert records? jerry joe king	by ryguy7272	1	322
Page break or Fit to Page Macro wigs	by wigs	0	573
Date formula question Jim Peterson	by Jim Peterson	4	395
Absolute Sumif Anthony	by Mike H	1	1,178
extend information into cells after doing subtotal Excel kblostyankee	by JonR	1	637
Changing to Proper Case Susan Nauceder	by Susan Nauceder	3	563
Adding only part of a column of data kajones	by kajones	3	355
Specify a font from a formula? Jo	by Jo	2	1,026
Expiry of Excel shee Hardeep kanwar	by hardeep.kanwar[_5_]	14	1,465
multiple columns applied with one picklist SKYDEX	by Francis	1	779
narrowing down records in another worksheet In-Thought	by In-Thought	0	312
Options for DIV#/0 jday	by Rick Rothstein	6	347
Sumproduct lisay	by Sheeloo[_4_]	1	361
IF OR bob	by Bob Phillips	1	315
About the usage of the function Keith Hui	by Luke M	1	611
sumif Graham	by Francis	3	446
vlookup error RR	by Max	1	512
sum cells depending on color of cell Morten	by Gary''s Student	1	531
Comment box LAW	by Gary''s Student	1	412
Please help! Macros LiAD	by Dave Peterson	1	282
How to show Excel Worksheets in two screens? Bannie	by Niek Otten	1	1,321
Solver with text LiAD	by LiAD	0	359
How can I construct a league table from a list of sports results? Torres99	by Pete_UK[_4_]	3	715
COUNTIF and multiple criteria Jonathan589	by Francis	5	365
Sheet Name Font Size KC Excel Qns	by KC ppt Qns	3	1,199
How can I reference a cell within a formula Alaska_Word_novice	by Rick Rothstein	3	367
Nest 3 SUMPRODUCT formulas - Possible? Bert T	by Bert T	7	448
Finding the cell with a specified string Don Kline[_2_]	by Ron Rosenfeld	4	481
trying to update a cell with new data based on vlookup functions Buzz	by Buzz	0	498
Help with adding times to give the result as the day Jimbo	by T. Valko	3	321
Array with multiple selection criteria Robert Robinson	by Ashish Mathur[_2_]	9	606
How to get my total back? Earleb	by T. Valko	9	405
How do i strip off Upper case Characters to another cell in Excel. gugertmk	by gugertmk	12	871
How can I refer to sheet number not sheet (name)? DK	by DK	2	504
need a function that will work using multiple work books and sheet capt c	by MyVeryOwnSelf[_2_]	1	566
Sumif by month and year Josh Hendrickson[_2_]	by T. Valko	7	1,617
vlookup function that returns the greates/oldest of many to one confused!!	by T. Valko	3	550