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,306
formula result is zero but zero is not populating in cell [email protected]	by Sheeloo[_4_]	3	784
Array formula: how to join 2 ranges together to form one array? Rich_84	by Dave Peterson	2	2,717
Rate of change Mike	by Mike	4	827
Returning to multiple data fields pivot table view ohadn77	by ohadn77	0	398
help with formulas??? Natasha	by Ross	2	298
summing 2 to 8 separate numbers in a single cell Green Fox	by Green Fox	2	1,129
Conversion help Iriemon	by OssieMac	1	390
PERCENTAGE OF VACANCY michelle wilson	by Mike H	2	719
Freeze Pane option in Vista Jen	by Je	2	389
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	354
Averaging Blank Cells John Calder	by Dave Peterson	4	519
Macro warning - how to delete macro GavinS	by Dave Peterson	3	803
How to insert $ and ‚¬ amounts in the same worksheet? Neophyte[_2_]	by Jacob Skaria	1	360
Hierarchical outlining Michael.Tarnowski	by Jacob Skaria	2	339
Sum Result of lookup in excel 2007 David Ryan	by David Ryan	5	522
Hyperlink problem Petervan	by Héctor Miguel	1	351
Timed macros LiAD	by LiAD	5	344
Recording macro usage LiAD	by LiAD	8	475
XIRR over several years Don Kline[_2_]	by JoeU2004	11	979
help with look up formula Bob Bob	by Bob Bob	5	384
Add values in "P" that fall between dates "03/01/00 and 03/31/00" Art	by macropod[_2_]	6	395
extract row number from Pivot Table Result gtslabs	by Max	1	1,237
Name Worksheet MCheru	by MCheru	6	370
Rows to columns Chris	by Chris	2	301
Formula Harish	by Harish	6	1,051
VLOOKUP & Array AlanR	by T. Valko	8	464
Need Function/Formula that will add a column based on two conditon SW[_2_]	by T. Valko	3	320
Conditional SUM Mike McLellan	by Ashish Mathur[_2_]	2	335
Grouping above in Excel 2007 SJKM	by Sheeloo[_4_]	7	1,261
add-in manager tleehh	by ryguy7272	1	574
Collapsing/expanding grouped areas on multiple pages Maxsteel	by ryguy7272	1	589
Vlookup returning NA when referencing cell data to another sheet Giacomo[_2_]	by T. Valko	3	1,397
how to sum quite a bit of duplicates into a cell bb sprgfld	by bb sprgfld[_2_]	3	464
finding a match SandyL	by SandyL	2	342
Formula won't calculate lindahamilton	by Sarge	4	339
insert records? jerry joe king	by ryguy7272	1	309
Page break or Fit to Page Macro wigs	by wigs	0	558
Date formula question Jim Peterson	by Jim Peterson	4	384
Absolute Sumif Anthony	by Mike H	1	1,168
extend information into cells after doing subtotal Excel kblostyankee	by JonR	1	620
Changing to Proper Case Susan Nauceder	by Susan Nauceder	3	521
Adding only part of a column of data kajones	by kajones	3	342
Specify a font from a formula? Jo	by Jo	2	1,002
Expiry of Excel shee Hardeep kanwar	by hardeep.kanwar[_5_]	14	1,455
multiple columns applied with one picklist SKYDEX	by Francis	1	773
narrowing down records in another worksheet In-Thought	by In-Thought	0	300
Options for DIV#/0 jday	by Rick Rothstein	6	334
Sumproduct lisay	by Sheeloo[_4_]	1	351
IF OR bob	by Bob Phillips	1	305
About the usage of the function Keith Hui	by Luke M	1	587
sumif Graham	by Francis	3	433
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	404
Please help! Macros LiAD	by Dave Peterson	1	275
How to show Excel Worksheets in two screens? Bannie	by Niek Otten	1	1,311
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	692
COUNTIF and multiple criteria Jonathan589	by Francis	5	355
Sheet Name Font Size KC Excel Qns	by KC ppt Qns	3	1,189
How can I reference a cell within a formula Alaska_Word_novice	by Rick Rothstein	3	361
Nest 3 SUMPRODUCT formulas - Possible? Bert T	by Bert T	7	439
Finding the cell with a specified string Don Kline[_2_]	by Ron Rosenfeld	4	454
trying to update a cell with new data based on vlookup functions Buzz	by Buzz	0	482
Help with adding times to give the result as the day Jimbo	by T. Valko	3	312
Array with multiple selection criteria Robert Robinson	by Ashish Mathur[_2_]	9	575
How to get my total back? Earleb	by T. Valko	9	395
How do i strip off Upper case Characters to another cell in Excel. gugertmk	by gugertmk	12	848
How can I refer to sheet number not sheet (name)? DK	by DK	2	486
need a function that will work using multiple work books and sheet capt c	by MyVeryOwnSelf[_2_]	1	534
Sumif by month and year Josh Hendrickson[_2_]	by T. Valko	7	1,610
vlookup function that returns the greates/oldest of many to one confused!!	by T. Valko	3	528