Excel Worksheet Functions - Page 212

Thread / Thread Starter	Last Post	Replies	Views
Modify search function Dinesh	by Ashish Mathur[_2_]	3	414
Excel Formula to evaluate multiple criteria (countif + and) VPSales	by Ashish Mathur[_2_]	2	622
Count text within numbers LiAD	by Ashish Mathur[_2_]	4	330
sumproduct formula work around Chris	by T. Valko	11	1,081
excel 2003 Quandary	by Gord Dibben	1	294
Eliminating #DIV/O! MCheru	by MCheru	6	588
ogh, why is this not working [email protected]	by Sheeloo[_4_]	1	367
sot data daniel	by Gord Dibben	2	401
SUMIF Function ? Joey	by Gary''s Student	1	345
Force required entry in cell before leaving that cell Retired Bill	by Gord Dibben	8	1,435
Count frequence in one column Excel Sum function with IF[_2_]	by Elkar	1	327
Email message on cell change event jknapp1005	by Ron de Bruin	1	534
Vlookup question zot	by T. Valko	2	690
Sumproduct and Networkdays Together J_L_G[_2_]	by J_L_G[_2_]	2	882
#DIV/O! Error Chris	by T. Valko	5	782
Sort not saved across saves/reopens Shane Devenshire	by Kris	1	321
#DIV/0 Error Dianne HMM	by Shane Devenshire	4	523
Run time error ub	by ub	2	337
Row 1 Deleted Deborah M	by Deborah M	0	454
Blank Cells showing as 0 in pivot DLoewenthal	by DLoewenthal	2	1,101
Resolve Conflict error ub	by ub	0	446
How to control drop down list width DocBrown	by Gord Dibben	4	1,534
vlookup & Extrapolation alawi	by Bernd P	3	1,312
If A1 = 4, cut and paste a2:a227 to a specific worksheet Mark B.	by Mark B.	2	632
How to use RIGHT() in sumproduct chrisk	by Gary''s Student	1	1,050
Can a column of numbers be set to mix up in random order KayD	by N harkawat	1	3,328
Refresh pivot table in workbook A when changing a cell in workbook gildengorin	by gildengorin	2	1,137
How to password Protect when WORKSHEET is Very HIDDEN Invisible	by Harlan Grove[_2_]	6	4,038
Macro assistance Rover	by Hansueli	11	1,064
Identifying the # of cells containing data WA	by Dave Peterson	2	504
remove the cells contents (data) without removing formulas Excel 2 onebigred51	by Gord Dibben	2	524
az GOV'[email protected]	by GOV'[email protected]	0	279
Return 3D array? Dave P[_3_]	by BlueJay	6	443
remove space capreecorn	by David Biddulph[_2_]	4	1,066
If statements query JayM	by Teethless mama	4	383
COUNT IF with multiple conditions Ghalmaraz	by Hansueli	5	384
Adding and multiplying suroora	by suroora	2	429
Search for duplicate entries in a column of numbers EÃ¡n[_2_]	by Gary''s Student	2	508
Expanding Grouped Rows when sheet is Protected SimonB[_2_]	by SimonB[_2_]	2	2,369
Data merging with 2 worksheets markmerid	by Shane Devenshire	2	394
Sort automatically MAX	by Shane Devenshire	2	459
Date/Time concatenation Al	by Shane Devenshire	4	358
countif only when an exact match occurs Mike	by Mike	5	2,060
Count every group of numbers whose sum is zero & put formula next toeach number al	by al	7	494
Summing based on values in other worksheets chickalina	by chickalina	2	468
Lookup / Match ? Mike B	by David Biddulph[_2_]	8	411
Concatenate With Criteria Tracey	by Tracey	5	763
Formula to identify text into columns Forgone	by Jarek Kujawa[_2_]	7	516
MOREFUNC lehigh46	by Bob Phillips[_3_]	1	507
Link updates Excel 2007 Alain Schneiter	by Alain Schneiter[_2_]	6	553
vlookup 2 arguments lab-guy	by Shane Devenshire	4	366
Comparing Excel Dates Dashman	by Dashman	5	813
How do I do A repeated measures ANOVA on Excel 2007??? Molly F	by Shane Devenshire	1	6,004
Lookup closest to sgl	by Ashish Mathur[_2_]	5	391
Whats wrong with this function? Angelsnecropolis	by Shane Devenshire	5	375
Euroconvert function in Excel 2000 returns a #NAME? pasqualejr	by pasqualejr	0	586
Attach code MAX	by MAX	5	367
Conditional Formatting Joe Gieder	by Joe Gieder	2	343
Outline/group data below Steve[_4_]	by Steve[_4_]	0	518
basketball bracket tonyalt3	by Dave Peterson	5	878
Formula/Function for Counting Characters in a cell CyndiR	by Gord Dibben	4	1,063
Even or Odd Year Function Dave H	by rspowell	3	1,489
call external function DavidB	by DavidB	2	526
Linking cells within workbook with ALL formating ATworker	by ATworker	3	695
Vlookup to find a match in a string KCK	by KCK	6	1,670
Cell not showing all letters in text DuPage	by Shane Devenshire	5	581
Function to count clock reaching 24 hours Veronica	by Shane Devenshire	3	495
Pivot Table multiple grand totals RoofIL	by Herbert Seidenberg	4	2,588
format ? Soth	by Pete_UK	3	331
Match consolidate multiple rows data into one row francis	by francis	4	1,165
How do I delete a Hyperlink in a cell Ellen	by Shane Devenshire	2	389
Concatenate: in an IF Function Tracey	by Ron Coderre[_3_]	6	565
Wrong output returned during IF function jb333	by T. Valko	3	479
alternate for Trace precedent zen	by zen	5	497
DATE AND TIME CONVERSION HELP John T[_2_]	by Shane Devenshire	2	377