Excel Worksheet Functions - Page 48

Thread / Thread Starter	Last Post	Replies	Views
If iserror help Help in nottingham	by Eduardo	1	594
Automatically filling a cell from a worksheet based on a selection Pbrent	by Roger Govier[_8_]	2	884
Using wild card characters in Find & Replace Tola	by Roger Govier[_8_]	3	1,761
Converting Excel to HTML Christopher Naveen[_2_]	by Christopher Naveen[_2_]	0	560
Convert excel to HTML Christopher Naveen[_2_]	by Christopher Naveen[_2_]	0	601
A list which don not include zero Manos	by Ms-Exl-Learner	5	569
Countif gone wrong Isis	by Mike H	2	1,335
Show zero values in specific area IanC[_2_]	by IanC[_2_]	4	740
How do I fill nonadjacent cells? Momby	by Fred Smith[_4_]	1	565
Need help to create a macro Igneshwara reddy[_2_]	by Billy Liddel	1	543
Copy Top 10 conditional formatting down 1000+ rows AdrianTCP	by Bob Ryan	1	1,287
Variable Sumproduct Range Tony	by T. Valko	6	645
Sort data separated by commas dab	by Ashish Mathur[_2_]	4	4,320
editing cells automatically??? yogiiyogee	by Gord Dibben	1	719
FORMULA'S MATTQHL	by Glenn	2	681
Changing a formula to read a general value? Zuo	by T. Valko	1	716
Combination of IF, AND, and COUNTIF; need help KL[_2_]	by KL[_2_]	6	6,575
count of number of rows within a range with a certain text cooey	by Bernd P	5	1,080
RONA Spreadsheet Dan	by Brad	1	1,404
sumif across multiple sheets in excel 2007 based on a condition dave@homedeliverygroup	by T. Valko	6	2,882
convert matrices to table Dave[_14_]	by Glenn	3	804
Formulas to Numbers MAD	by Jacob Skaria	2	701
Average with Conditions Curtis[_2_]	by Jacob Skaria	1	745
Conditional formating dates Teeny	by Jacob Skaria	2	631
How can I set up a shortcut key for Autosum? dsapan	by CD	3	1,355
Grouping and sorting details Rich Stone	by Glenn	7	713
Lookups and ifs! Annie	by Roger Govier[_8_]	2	449
Adding VLOOKUPS across multiple worksheets NCarter	by DKS	3	2,235
Get rid of #DIV/0! without repeating denominator? Go Bucks!!![_2_]	by Chris Oosthuizen	10	1,569
Using Custom Views with Protected Worksheets Beverly	by Beverly	2	1,006
Time Format Question Toria	by T. Valko	6	796
SD0310 -how do I just get the numbers at the end in cell after Helen Maguire	by L. Howard Kittle	5	992
Ziping excel 2007? excelleration	by David Biddulph[_2_]	1	535
populate month-yyyy when compare 2 cells AskExcel	by AskExcel	3	819
runtime error code 1004 Karen	by Dave Peterson[_2_]	1	1,026
Zero and Null Sum Function Frustrated by Averages[_2_]	by Frustrated by Averages[_2_]	3	1,459
Cell Function/Font Color HpyTrvlr69	by HpyTrvlr69	2	1,378
Finding next number in a series Iriemon	by T. Valko	2	2,104
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string Raja Mahendiran S	by Raja Mahendiran S[_2_]	6	2,124
Conditional Formats, how to scroll and view all formats? Bill E	by Bill E	0	667
IF formula help? daisy	by Ms-Exl-Learner	5	589
Formula Help Danny Boy	by Danny Boy	5	705
Worksheet Function required Hammer[_2_]	by Billy Liddel	2	632
VLOOKUP Lbengston	by Jacob Skaria	1	560
Shading in cells is not printing....HELP! aquams	by Gord Dibben	1	1,939
If date matches and formula hasn't already been calculated previou LON205	by LON205	0	587
create lags for forecasting k15y8	by k15y8	0	1,092
How to calculate diffrence in dates in days and Hours MsLearner	by Jacob Skaria	6	624
YTD with conditions MrRJ	by MrRJ	2	598
formula to subtract 60 days from a date (05/25/2010) 2003excel HH	by Fred Smith[_4_]	3	4,476
Function Error IF Statement Bob Zimmerman	by Bob Zimmerman	3	699
formula to return value from a matrix - I know hor and vert values UKMAN	by Don Guillett[_2_]	14	2,256
i enter value in one column the next column existing value turn 0 Bonnie	by ozgrid.com	1	628
Receive data in column with pull down TooN	by Jacob Skaria	2	709
Nesting IF Statement in excel 2007 Mezani	by Brad	2	843
Remove Text From AlphaNumeric Bam	by Jacob Skaria	11	6,301
VLOOKUP use column name not number kathy	by T. Valko	7	3,710
Copy If rows to another worksheet Georgeb123	by Ashish Mathur[_2_]	1	704
Index and Match winnie123	by Steve Dunn	3	587
vlookup across multiple pages Mazkot	by Mazkot	2	840
Data Validation Lost Cluster	by zvkmpw	4	661
Average range of discontinuous cells Nadine	by Nadine	1	1,240
Countif help needed Jessica Krall	by T. Valko	6	825
How do I limit formula results to positive only? mathjegna	by Peo Sjoblom[_3_]	4	4,404
Auto fill Cells with text Robzz	by Paul C	2	1,080
update the hyperlink in file after changing the file name Bel71	by Steve Dunn	3	1,051
How do I average every 3rd cell in a column of a spreadsheet? Sean	by Steve Dunn	3	1,546
How to Auto Reference Worksheet Tab ID's in Formulas? Scott - Key West[_2_]	by Gord Dibben	9	1,288
Average Length of Stay Georgeb123	by Ashish Mathur[_2_]	2	4,425
sheet protection with links sthart	by Eduardo	1	540
horizontal scroll bar Brian Wehrs	by Dave Peterson[_2_]	1	1,672
Where does Max keep his files now ? darkblue	by darkblue	4	794
Match 2 Columns, Return 3rd, Differing Match Types Matt.Russett	by Steve Dunn	3	2,012
Adding to a SUMPRODUCT formula Mark D[_2_]	by Steve Dunn	6	775
Need suggestions on layout to report/pivot Nadine	by Roger Govier[_8_]	3	519