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,326
formula result is zero but zero is not populating in cell [email protected]	by Sheeloo[_4_]	3	817
Array formula: how to join 2 ranges together to form one array? Rich_84	by Dave Peterson	2	2,770
Rate of change Mike	by Mike	4	837
Returning to multiple data fields pivot table view ohadn77	by ohadn77	0	414
help with formulas??? Natasha	by Ross	2	315
summing 2 to 8 separate numbers in a single cell Green Fox	by Green Fox	2	1,148
Conversion help Iriemon	by OssieMac	1	407
PERCENTAGE OF VACANCY michelle wilson	by Mike H	2	733
Freeze Pane option in Vista Jen	by Je	2	406
Macro Buttons Lois	by Jacob Skaria	4	485
macro apply to all worksheet AskExcel	by Jacob Skaria	3	880
Need your help with formulas in excel!! michelle wilson	by Dave	7	376
Averaging Blank Cells John Calder	by Dave Peterson	4	534
Macro warning - how to delete macro GavinS	by Dave Peterson	3	837
How to insert $ and ‚¬ amounts in the same worksheet? Neophyte[_2_]	by Jacob Skaria	1	383
Hierarchical outlining Michael.Tarnowski	by Jacob Skaria	2	352
Sum Result of lookup in excel 2007 David Ryan	by David Ryan	5	548
Hyperlink problem Petervan	by Héctor Miguel	1	377
Timed macros LiAD	by LiAD	5	360
Recording macro usage LiAD	by LiAD	8	512
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	418
extract row number from Pivot Table Result gtslabs	by Max	1	1,267
Name Worksheet MCheru	by MCheru	6	381
Rows to columns Chris	by Chris	2	318
Formula Harish	by Harish	6	1,084
VLOOKUP & Array AlanR	by T. Valko	8	499
Need Function/Formula that will add a column based on two conditon SW[_2_]	by T. Valko	3	338
Conditional SUM Mike McLellan	by Ashish Mathur[_2_]	2	361
Grouping above in Excel 2007 SJKM	by Sheeloo[_4_]	7	1,293
add-in manager tleehh	by ryguy7272	1	594
Collapsing/expanding grouped areas on multiple pages Maxsteel	by ryguy7272	1	617
Vlookup returning NA when referencing cell data to another sheet Giacomo[_2_]	by T. Valko	3	1,435
how to sum quite a bit of duplicates into a cell bb sprgfld	by bb sprgfld[_2_]	3	510
finding a match SandyL	by SandyL	2	364
Formula won't calculate lindahamilton	by Sarge	4	353
insert records? jerry joe king	by ryguy7272	1	324
Page break or Fit to Page Macro wigs	by wigs	0	576
Date formula question Jim Peterson	by Jim Peterson	4	403
Absolute Sumif Anthony	by Mike H	1	1,178
extend information into cells after doing subtotal Excel kblostyankee	by JonR	1	648
Changing to Proper Case Susan Nauceder	by Susan Nauceder	3	573
Adding only part of a column of data kajones	by kajones	3	368
Specify a font from a formula? Jo	by Jo	2	1,041
Expiry of Excel shee Hardeep kanwar	by hardeep.kanwar[_5_]	14	1,469
multiple columns applied with one picklist SKYDEX	by Francis	1	793
narrowing down records in another worksheet In-Thought	by In-Thought	0	312
Options for DIV#/0 jday	by Rick Rothstein	6	348
Sumproduct lisay	by Sheeloo[_4_]	1	365
IF OR bob	by Bob Phillips	1	321
About the usage of the function Keith Hui	by Luke M	1	619
sumif Graham	by Francis	3	451
vlookup error RR	by Max	1	522
sum cells depending on color of cell Morten	by Gary''s Student	1	541
Comment box LAW	by Gary''s Student	1	412
Please help! Macros LiAD	by Dave Peterson	1	293
How to show Excel Worksheets in two screens? Bannie	by Niek Otten	1	1,321
Solver with text LiAD	by LiAD	0	371
How can I construct a league table from a list of sports results? Torres99	by Pete_UK[_4_]	3	716
COUNTIF and multiple criteria Jonathan589	by Francis	5	372
Sheet Name Font Size KC Excel Qns	by KC ppt Qns	3	1,205
How can I reference a cell within a formula Alaska_Word_novice	by Rick Rothstein	3	380
Nest 3 SUMPRODUCT formulas - Possible? Bert T	by Bert T	7	455
Finding the cell with a specified string Don Kline[_2_]	by Ron Rosenfeld	4	491
trying to update a cell with new data based on vlookup functions Buzz	by Buzz	0	499
Help with adding times to give the result as the day Jimbo	by T. Valko	3	334
Array with multiple selection criteria Robert Robinson	by Ashish Mathur[_2_]	9	622
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	880
How can I refer to sheet number not sheet (name)? DK	by DK	2	508
need a function that will work using multiple work books and sheet capt c	by MyVeryOwnSelf[_2_]	1	575
Sumif by month and year Josh Hendrickson[_2_]	by T. Valko	7	1,623
vlookup function that returns the greates/oldest of many to one confused!!	by T. Valko	3	559