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,305
formula result is zero but zero is not populating in cell [email protected]	by Sheeloo[_4_]	3	782
Array formula: how to join 2 ranges together to form one array? Rich_84	by Dave Peterson	2	2,712
Rate of change Mike	by Mike	4	826
Returning to multiple data fields pivot table view ohadn77	by ohadn77	0	397
help with formulas??? Natasha	by Ross	2	288
summing 2 to 8 separate numbers in a single cell Green Fox	by Green Fox	2	1,128
Conversion help Iriemon	by OssieMac	1	390
PERCENTAGE OF VACANCY michelle wilson	by Mike H	2	718
Freeze Pane option in Vista Jen	by Je	2	384
Macro Buttons Lois	by Jacob Skaria	4	451
macro apply to all worksheet AskExcel	by Jacob Skaria	3	866
Need your help with formulas in excel!! michelle wilson	by Dave	7	352
Averaging Blank Cells John Calder	by Dave Peterson	4	518
Macro warning - how to delete macro GavinS	by Dave Peterson	3	798
How to insert $ and ‚¬ amounts in the same worksheet? Neophyte[_2_]	by Jacob Skaria	1	359
Hierarchical outlining Michael.Tarnowski	by Jacob Skaria	2	338
Sum Result of lookup in excel 2007 David Ryan	by David Ryan	5	520
Hyperlink problem Petervan	by Héctor Miguel	1	349
Timed macros LiAD	by LiAD	5	344
Recording macro usage LiAD	by LiAD	8	473
XIRR over several years Don Kline[_2_]	by JoeU2004	11	975
help with look up formula Bob Bob	by Bob Bob	5	383
Add values in "P" that fall between dates "03/01/00 and 03/31/00" Art	by macropod[_2_]	6	394
extract row number from Pivot Table Result gtslabs	by Max	1	1,234
Name Worksheet MCheru	by MCheru	6	369
Rows to columns Chris	by Chris	2	298
Formula Harish	by Harish	6	1,050
VLOOKUP & Array AlanR	by T. Valko	8	462
Need Function/Formula that will add a column based on two conditon SW[_2_]	by T. Valko	3	318
Conditional SUM Mike McLellan	by Ashish Mathur[_2_]	2	334
Grouping above in Excel 2007 SJKM	by Sheeloo[_4_]	7	1,260
add-in manager tleehh	by ryguy7272	1	572
Collapsing/expanding grouped areas on multiple pages Maxsteel	by ryguy7272	1	587
Vlookup returning NA when referencing cell data to another sheet Giacomo[_2_]	by T. Valko	3	1,395
how to sum quite a bit of duplicates into a cell bb sprgfld	by bb sprgfld[_2_]	3	458
finding a match SandyL	by SandyL	2	342
Formula won't calculate lindahamilton	by Sarge	4	338
insert records? jerry joe king	by ryguy7272	1	308
Page break or Fit to Page Macro wigs	by wigs	0	556
Date formula question Jim Peterson	by Jim Peterson	4	381
Absolute Sumif Anthony	by Mike H	1	1,167
extend information into cells after doing subtotal Excel kblostyankee	by JonR	1	618
Changing to Proper Case Susan Nauceder	by Susan Nauceder	3	517
Adding only part of a column of data kajones	by kajones	3	340
Specify a font from a formula? Jo	by Jo	2	1,001
Expiry of Excel shee Hardeep kanwar	by hardeep.kanwar[_5_]	14	1,455
multiple columns applied with one picklist SKYDEX	by Francis	1	772
narrowing down records in another worksheet In-Thought	by In-Thought	0	299
Options for DIV#/0 jday	by Rick Rothstein	6	333
Sumproduct lisay	by Sheeloo[_4_]	1	349
IF OR bob	by Bob Phillips	1	304
About the usage of the function Keith Hui	by Luke M	1	581
sumif Graham	by Francis	3	432
vlookup error RR	by Max	1	505
sum cells depending on color of cell Morten	by Gary''s Student	1	508
Comment box LAW	by Gary''s Student	1	403
Please help! Macros LiAD	by Dave Peterson	1	272
How to show Excel Worksheets in two screens? Bannie	by Niek Otten	1	1,309
Solver with text LiAD	by LiAD	0	354
How can I construct a league table from a list of sports results? Torres99	by Pete_UK[_4_]	3	690
COUNTIF and multiple criteria Jonathan589	by Francis	5	354
Sheet Name Font Size KC Excel Qns	by KC ppt Qns	3	1,188
How can I reference a cell within a formula Alaska_Word_novice	by Rick Rothstein	3	360
Nest 3 SUMPRODUCT formulas - Possible? Bert T	by Bert T	7	437
Finding the cell with a specified string Don Kline[_2_]	by Ron Rosenfeld	4	451
trying to update a cell with new data based on vlookup functions Buzz	by Buzz	0	479
Help with adding times to give the result as the day Jimbo	by T. Valko	3	310
Array with multiple selection criteria Robert Robinson	by Ashish Mathur[_2_]	9	574
How to get my total back? Earleb	by T. Valko	9	394
How do i strip off Upper case Characters to another cell in Excel. gugertmk	by gugertmk	12	846
How can I refer to sheet number not sheet (name)? DK	by DK	2	484
need a function that will work using multiple work books and sheet capt c	by MyVeryOwnSelf[_2_]	1	531
Sumif by month and year Josh Hendrickson[_2_]	by T. Valko	7	1,607
vlookup function that returns the greates/oldest of many to one confused!!	by T. Valko	3	523