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,316
formula result is zero but zero is not populating in cell [email protected]	by Sheeloo[_4_]	3	804
Array formula: how to join 2 ranges together to form one array? Rich_84	by Dave Peterson	2	2,748
Rate of change Mike	by Mike	4	834
Returning to multiple data fields pivot table view ohadn77	by ohadn77	0	408
help with formulas??? Natasha	by Ross	2	310
summing 2 to 8 separate numbers in a single cell Green Fox	by Green Fox	2	1,141
Conversion help Iriemon	by OssieMac	1	400
PERCENTAGE OF VACANCY michelle wilson	by Mike H	2	731
Freeze Pane option in Vista Jen	by Je	2	402
Macro Buttons Lois	by Jacob Skaria	4	471
macro apply to all worksheet AskExcel	by Jacob Skaria	3	878
Need your help with formulas in excel!! michelle wilson	by Dave	7	361
Averaging Blank Cells John Calder	by Dave Peterson	4	532
Macro warning - how to delete macro GavinS	by Dave Peterson	3	823
How to insert $ and ‚¬ amounts in the same worksheet? Neophyte[_2_]	by Jacob Skaria	1	370
Hierarchical outlining Michael.Tarnowski	by Jacob Skaria	2	343
Sum Result of lookup in excel 2007 David Ryan	by David Ryan	5	536
Hyperlink problem Petervan	by Héctor Miguel	1	361
Timed macros LiAD	by LiAD	5	350
Recording macro usage LiAD	by LiAD	8	494
XIRR over several years Don Kline[_2_]	by JoeU2004	11	987
help with look up formula Bob Bob	by Bob Bob	5	397
Add values in "P" that fall between dates "03/01/00 and 03/31/00" Art	by macropod[_2_]	6	408
extract row number from Pivot Table Result gtslabs	by Max	1	1,254
Name Worksheet MCheru	by MCheru	6	374
Rows to columns Chris	by Chris	2	312
Formula Harish	by Harish	6	1,083
VLOOKUP & Array AlanR	by T. Valko	8	483
Need Function/Formula that will add a column based on two conditon SW[_2_]	by T. Valko	3	327
Conditional SUM Mike McLellan	by Ashish Mathur[_2_]	2	346
Grouping above in Excel 2007 SJKM	by Sheeloo[_4_]	7	1,277
add-in manager tleehh	by ryguy7272	1	586
Collapsing/expanding grouped areas on multiple pages Maxsteel	by ryguy7272	1	602
Vlookup returning NA when referencing cell data to another sheet Giacomo[_2_]	by T. Valko	3	1,420
how to sum quite a bit of duplicates into a cell bb sprgfld	by bb sprgfld[_2_]	3	497
finding a match SandyL	by SandyL	2	350
Formula won't calculate lindahamilton	by Sarge	4	348
insert records? jerry joe king	by ryguy7272	1	318
Page break or Fit to Page Macro wigs	by wigs	0	569
Date formula question Jim Peterson	by Jim Peterson	4	393
Absolute Sumif Anthony	by Mike H	1	1,175
extend information into cells after doing subtotal Excel kblostyankee	by JonR	1	635
Changing to Proper Case Susan Nauceder	by Susan Nauceder	3	562
Adding only part of a column of data kajones	by kajones	3	353
Specify a font from a formula? Jo	by Jo	2	1,024
Expiry of Excel shee Hardeep kanwar	by hardeep.kanwar[_5_]	14	1,461
multiple columns applied with one picklist SKYDEX	by Francis	1	777
narrowing down records in another worksheet In-Thought	by In-Thought	0	311
Options for DIV#/0 jday	by Rick Rothstein	6	344
Sumproduct lisay	by Sheeloo[_4_]	1	360
IF OR bob	by Bob Phillips	1	312
About the usage of the function Keith Hui	by Luke M	1	610
sumif Graham	by Francis	3	444
vlookup error RR	by Max	1	510
sum cells depending on color of cell Morten	by Gary''s Student	1	531
Comment box LAW	by Gary''s Student	1	411
Please help! Macros LiAD	by Dave Peterson	1	280
How to show Excel Worksheets in two screens? Bannie	by Niek Otten	1	1,319
Solver with text LiAD	by LiAD	0	356
How can I construct a league table from a list of sports results? Torres99	by Pete_UK[_4_]	3	708
COUNTIF and multiple criteria Jonathan589	by Francis	5	362
Sheet Name Font Size KC Excel Qns	by KC ppt Qns	3	1,195
How can I reference a cell within a formula Alaska_Word_novice	by Rick Rothstein	3	365
Nest 3 SUMPRODUCT formulas - Possible? Bert T	by Bert T	7	447
Finding the cell with a specified string Don Kline[_2_]	by Ron Rosenfeld	4	479
trying to update a cell with new data based on vlookup functions Buzz	by Buzz	0	493
Help with adding times to give the result as the day Jimbo	by T. Valko	3	320
Array with multiple selection criteria Robert Robinson	by Ashish Mathur[_2_]	9	597
How to get my total back? Earleb	by T. Valko	9	403
How do i strip off Upper case Characters to another cell in Excel. gugertmk	by gugertmk	12	870
How can I refer to sheet number not sheet (name)? DK	by DK	2	503
need a function that will work using multiple work books and sheet capt c	by MyVeryOwnSelf[_2_]	1	557
Sumif by month and year Josh Hendrickson[_2_]	by T. Valko	7	1,616
vlookup function that returns the greates/oldest of many to one confused!!	by T. Valko	3	543