Excel Worksheet Functions - Page 212

Thread / Thread Starter	Last Post	Replies	Views
Modify search function Dinesh	by Ashish Mathur[_2_]	3	446
Excel Formula to evaluate multiple criteria (countif + and) VPSales	by Ashish Mathur[_2_]	2	684
Count text within numbers LiAD	by Ashish Mathur[_2_]	4	351
sumproduct formula work around Chris	by T. Valko	11	1,093
excel 2003 Quandary	by Gord Dibben	1	308
Eliminating #DIV/O! MCheru	by MCheru	6	612
ogh, why is this not working [email protected]	by Sheeloo[_4_]	1	387
sot data daniel	by Gord Dibben	2	414
SUMIF Function ? Joey	by Gary''s Student	1	371
Force required entry in cell before leaving that cell Retired Bill	by Gord Dibben	8	1,449
Count frequence in one column Excel Sum function with IF[_2_]	by Elkar	1	346
Email message on cell change event jknapp1005	by Ron de Bruin	1	564
Vlookup question zot	by T. Valko	2	708
Sumproduct and Networkdays Together J_L_G[_2_]	by J_L_G[_2_]	2	906
#DIV/O! Error Chris	by T. Valko	5	803
Sort not saved across saves/reopens Shane Devenshire	by Kris	1	347
#DIV/0 Error Dianne HMM	by Shane Devenshire	4	591
Run time error ub	by ub	2	354
Row 1 Deleted Deborah M	by Deborah M	0	478
Blank Cells showing as 0 in pivot DLoewenthal	by DLoewenthal	2	1,110
Resolve Conflict error ub	by ub	0	468
How to control drop down list width DocBrown	by Gord Dibben	4	1,589
vlookup & Extrapolation alawi	by Bernd P	3	1,343
If A1 = 4, cut and paste a2:a227 to a specific worksheet Mark B.	by Mark B.	2	648
How to use RIGHT() in sumproduct chrisk	by Gary''s Student	1	1,067
Can a column of numbers be set to mix up in random order KayD	by N harkawat	1	3,404
Refresh pivot table in workbook A when changing a cell in workbook gildengorin	by gildengorin	2	1,173
How to password Protect when WORKSHEET is Very HIDDEN Invisible	by Harlan Grove[_2_]	6	4,059
Macro assistance Rover	by Hansueli	11	1,078
Identifying the # of cells containing data WA	by Dave Peterson	2	537
remove the cells contents (data) without removing formulas Excel 2 onebigred51	by Gord Dibben	2	550
az GOV'[email protected]	by GOV'[email protected]	0	284
Return 3D array? Dave P[_3_]	by BlueJay	6	464
remove space capreecorn	by David Biddulph[_2_]	4	1,160
If statements query JayM	by Teethless mama	4	402
COUNT IF with multiple conditions Ghalmaraz	by Hansueli	5	402
Adding and multiplying suroora	by suroora	2	441
Search for duplicate entries in a column of numbers EÃ¡n[_2_]	by Gary''s Student	2	533
Expanding Grouped Rows when sheet is Protected SimonB[_2_]	by SimonB[_2_]	2	2,394
Data merging with 2 worksheets markmerid	by Shane Devenshire	2	409
Sort automatically MAX	by Shane Devenshire	2	482
Date/Time concatenation Al	by Shane Devenshire	4	378
countif only when an exact match occurs Mike	by Mike	5	2,099
Count every group of numbers whose sum is zero & put formula next toeach number al	by al	7	517
Summing based on values in other worksheets chickalina	by chickalina	2	491
Lookup / Match ? Mike B	by David Biddulph[_2_]	8	424
Concatenate With Criteria Tracey	by Tracey	5	776
Formula to identify text into columns Forgone	by Jarek Kujawa[_2_]	7	533
MOREFUNC lehigh46	by Bob Phillips[_3_]	1	513
Link updates Excel 2007 Alain Schneiter	by Alain Schneiter[_2_]	6	581
vlookup 2 arguments lab-guy	by Shane Devenshire	4	381
Comparing Excel Dates Dashman	by Dashman	5	836
How do I do A repeated measures ANOVA on Excel 2007??? Molly F	by Shane Devenshire	1	6,023
Lookup closest to sgl	by Ashish Mathur[_2_]	5	405
Whats wrong with this function? Angelsnecropolis	by Shane Devenshire	5	392
Euroconvert function in Excel 2000 returns a #NAME? pasqualejr	by pasqualejr	0	619
Attach code MAX	by MAX	5	383
Conditional Formatting Joe Gieder	by Joe Gieder	2	390
Outline/group data below Steve[_4_]	by Steve[_4_]	0	535
basketball bracket tonyalt3	by Dave Peterson	5	908
Formula/Function for Counting Characters in a cell CyndiR	by Gord Dibben	4	1,085
Even or Odd Year Function Dave H	by rspowell	3	1,532
call external function DavidB	by DavidB	2	554
Linking cells within workbook with ALL formating ATworker	by ATworker	3	701
Vlookup to find a match in a string KCK	by KCK	6	1,692
Cell not showing all letters in text DuPage	by Shane Devenshire	5	610
Function to count clock reaching 24 hours Veronica	by Shane Devenshire	3	519
Pivot Table multiple grand totals RoofIL	by Herbert Seidenberg	4	2,613
format ? Soth	by Pete_UK	3	347
Match consolidate multiple rows data into one row francis	by francis	4	1,208
How do I delete a Hyperlink in a cell Ellen	by Shane Devenshire	2	406
Concatenate: in an IF Function Tracey	by Ron Coderre[_3_]	6	610
Wrong output returned during IF function jb333	by T. Valko	3	510
alternate for Trace precedent zen	by zen	5	511
DATE AND TIME CONVERSION HELP John T[_2_]	by Shane Devenshire	2	397