Excel Worksheet Functions - Page 924

Thread / Thread Starter	Last Post	Replies	Views
IF Formula Jemma	by Max	3	407
Add values of data that might have duplicate labels Tony	by Max	5	767
Count and Sum of cells if conditions fulfilled Bono	by Max	12	2,268
Vlookup with multiple reference Yanky	by Pete_UK	1	741
Worksheet, workbook password [email protected]	by Eduardo	1	352
argument separator not working rfk100	by rfk100	5	671
SUMIF function being used properly? frenchtoast	by Luke M	4	469
Automatically delete rows with any blank columns Kris	by Don Guillett	6	966
Insert a keyboard Character e.g (/)in multiple cells of a workshee Mike	by David Biddulph[_2_]	2	1,075
How do I change a cell reference every time there is a blank cell? Read	by Glenn	5	557
Subtotal Function - add formula to all blank rows Nikki	by Glenn	1	1,221
Ron DeBruin's Merge Worksheets Example ScottMSP	by ScottMSP	2	1,028
conditions and the max function kiersten	by Jarek Kujawa[_2_]	1	368
Inventory anjarama	by Eduardo	3	369
Lookup and #N/A Russell Johnson	by Teethless mama	3	452
Case Sensative Subtotaling wingsdihard2	by Teethless mama	3	297
Average time spent to # of events Jennifer	by Michael	2	610
Change colour based on date grateful	by xlm	6	528
How to shade cells based on formula of % growth/loss of last year? WHintz67	by muddan madhu	1	543
Get rid of DIV/0 error message Jeff	by Pete_UK	4	3,168
APY and Interest rate calculation boba[_2_]	by [email protected]	1	1,253
Conditional formatting Gilbert DE CEULAER	by mcescher	1	456
formula that will reference another worksheets info. same book Jeff Wood	by GuyHD	4	562
Adding Daily Jess	by David Biddulph[_2_]	4	356
Sums Jemma	by Ron Rosenfeld	6	515
Multiple criteria in autofilter BASFMark	by Michael	1	604
Sumproduct Sandy	by xlm	2	333
Assigning a variable Zack	by Pete_UK	3	461
how do I merge two excel sheets from one excel workbook Ash	by Gord Dibben	5	520
creating an IF macro in Excel 2003 Ronda	by Gord Dibben	7	557
Would if work? just4ucreations	by Eduardo	3	416
Latest value from table WRC	by T. Valko	3	466
Formula Question Davis	by Davis	3	429
Sum working days NM	by T. Valko	13	1,837
protect worksheet but allow row deletion Tia	by Michael	3	1,263
Convert GPA to Letter Grade Cindy	by Cindy	3	1,794
Pivot Table Shaylee	by Debra Dalgleish	1	460
Concatenation jknapp1005	by Chip Pearson	3	553
Using Pivot Table Data Mervyn Thomas[_2_]	by Debra Dalgleish	2	434
Conditional formatting Gilbert DE CEULAER	by Luke M	1	428
Missing Macro Tim at alliant	by Tim at alliant	7	996
Average exluding max and min values Paul	by T. Valko	11	1,319
sum of text positions Kevin	by Ron Rosenfeld	10	1,080
Indirect addressing for linked file ChEBass	by ChEBass	5	598
Searching for records with multiple criteria Jeff	by Jeff	7	567
Sumproduct repost Sandy	by [email protected]	8	466
Formual link to external workbook JBW	by Dave Peterson	2	685
I want to get and A to count as a 1 in Excel dclayton	by Glenn	2	467
VLOOKUP Auto fill problem Dylan @ UAFC[_2_]	by Fred Smith[_4_]	2	1,475
IF functions with multiple results including blank Steve	by T. Valko	7	403
Absoult for auto fill Dylan @ UAFC[_2_]	by Bernie Deitrick	1	354
Subtotal Nikki	by Pete_UK	3	419
how to get grand total in words in excel sheet gangadhar	by Gord Dibben	2	1,730
Find and Replace/Substitute Formulas Kathy123	by Pete_UK	4	581
VLOOKUP sydney	by Dylan @ UAFC[_2_]	2	424
how do I hide the #N/A to not show in the cell Dylan @ UAFC[_2_]	by Gord Dibben	1	515
Formula to look up duplicates Dylan @ UAFC[_2_]	by Gord Dibben	1	639
Creating inout values for excel nelly007	by Max	9	630
Problem with MATCH () function . . . Blue Max	by Blue Max	2	846
reverse lookup function, index/match usage? Ambie	by T. Valko	3	1,240
Totals linked from other sheets DUKE	by DUKE	0	477
Count Percentages in a range tldem	by David Biddulph[_2_]	4	422
MS Office 2003 Prof Ed SP2 Chinna122008	by Chinna122008	3	606
How to do if I would like to select from a list by using "IF" form cara	by T. Valko	3	524
How can I insert a row in a source that links to a destination Bob	by Max	1	695
Monthly job timings analysis - automation options? Paul	by Max	2	543
count on 3 criteria Chris Salcedo	by Jarek Kujawa[_2_]	3	427
Arrays Abdul Shakeel	by Pecoflyer[_42_]	1	535
Giving "X" a numerical value. floyd.anderson	by Jarek Kujawa[_2_]	7	750
How do i copy a vlookup formula into other cells going right km440	by Pete_UK	1	4,615
How to use AUTOFILTER to update FREQUENCY distribution zerocred	by zerocred	7	756
Using same fomula to count AND and OR options / sumproduct KCR	by Bernard Liengme	5	490
Advanced Filter returning complete database not filtered results DianeG	by Jarek Kujawa[_2_]	4	505
Conditional formatting Gilbert DE CEULAER	by Luke M	1	344
one user form multiples worksheets celio3c	by Susan	1	544