Excel Worksheet Functions - Page 972

Thread / Thread Starter	Last Post	Replies	Views
Link updates Excel 2007 Alain Schneiter	by Alain Schneiter[_2_]	6	554
MOREFUNC lehigh46	by Bob Phillips[_3_]	1	507
Formula to identify text into columns Forgone	by Jarek Kujawa[_2_]	7	516
Concatenate With Criteria Tracey	by Tracey	5	764
Lookup / Match ? Mike B	by David Biddulph[_2_]	8	411
Summing based on values in other worksheets chickalina	by chickalina	2	470
Count every group of numbers whose sum is zero & put formula next toeach number al	by al	7	498
countif only when an exact match occurs Mike	by Mike	5	2,064
Date/Time concatenation Al	by Shane Devenshire	4	362
Sort automatically MAX	by Shane Devenshire	2	460
Data merging with 2 worksheets markmerid	by Shane Devenshire	2	394
Expanding Grouped Rows when sheet is Protected SimonB[_2_]	by SimonB[_2_]	2	2,379
Search for duplicate entries in a column of numbers EÃ¡n[_2_]	by Gary''s Student	2	511
Adding and multiplying suroora	by suroora	2	430
COUNT IF with multiple conditions Ghalmaraz	by Hansueli	5	385
If statements query JayM	by Teethless mama	4	386
remove space capreecorn	by David Biddulph[_2_]	4	1,071
Return 3D array? Dave P[_3_]	by BlueJay	6	444
az GOV'[email protected]	by GOV'[email protected]	0	280
remove the cells contents (data) without removing formulas Excel 2 onebigred51	by Gord Dibben	2	526
Identifying the # of cells containing data WA	by Dave Peterson	2	509
Macro assistance Rover	by Hansueli	11	1,067
How to password Protect when WORKSHEET is Very HIDDEN Invisible	by Harlan Grove[_2_]	6	4,042
Refresh pivot table in workbook A when changing a cell in workbook gildengorin	by gildengorin	2	1,141
Can a column of numbers be set to mix up in random order KayD	by N harkawat	1	3,351
How to use RIGHT() in sumproduct chrisk	by Gary''s Student	1	1,058
If A1 = 4, cut and paste a2:a227 to a specific worksheet Mark B.	by Mark B.	2	636
vlookup & Extrapolation alawi	by Bernd P	3	1,315
How to control drop down list width DocBrown	by Gord Dibben	4	1,567
Resolve Conflict error ub	by ub	0	448
Blank Cells showing as 0 in pivot DLoewenthal	by DLoewenthal	2	1,104
Row 1 Deleted Deborah M	by Deborah M	0	456
Run time error ub	by ub	2	338
#DIV/0 Error Dianne HMM	by Shane Devenshire	4	528
Sort not saved across saves/reopens Shane Devenshire	by Kris	1	327
#DIV/O! Error Chris	by T. Valko	5	783
Sumproduct and Networkdays Together J_L_G[_2_]	by J_L_G[_2_]	2	883
Vlookup question zot	by T. Valko	2	698
Email message on cell change event jknapp1005	by Ron de Bruin	1	537
Count frequence in one column Excel Sum function with IF[_2_]	by Elkar	1	329
Force required entry in cell before leaving that cell Retired Bill	by Gord Dibben	8	1,436
SUMIF Function ? Joey	by Gary''s Student	1	349
sot data daniel	by Gord Dibben	2	404
ogh, why is this not working [email protected]	by Sheeloo[_4_]	1	369
Eliminating #DIV/O! MCheru	by MCheru	6	589
excel 2003 Quandary	by Gord Dibben	1	295
sumproduct formula work around Chris	by T. Valko	11	1,083
Count text within numbers LiAD	by Ashish Mathur[_2_]	4	333
Excel Formula to evaluate multiple criteria (countif + and) VPSales	by Ashish Mathur[_2_]	2	665
Modify search function Dinesh	by Ashish Mathur[_2_]	3	416
Nested If Statements Sarah_Lecturer	by Ashish Mathur[_2_]	5	380
Using the results of the ADDRESS formula in another formula JP	by T. Valko	4	462
Indirect with index and match Kashyap	by T. Valko	2	830
vlook up where one column has a range of numbers travos	by T. Valko	1	402
command line options/switches to print excel file Stranger[_2_]	by Stranger[_2_]	2	1,207
Max to min for dates LiAD	by Bernd P	2	458
Median by groups freefighter	by freefighter	0	475
Refer cell value as part of formula Abhay	by Stefi	1	631
how can I convert numberic value to text in english? Function New User	by Stefi	2	493
Making COUNTIF update in real time Bishop	by Michael.Tarnowski	4	4,125
refer cell value of another workbbok in formulae Abhay	by Domenic[_2_]	1	396
SCREEN NOT UPDATING ub	by ub	2	558
How to Spell Number in English? I mean write 1 & see One? KVS	by Ashish Mathur[_2_]	2	1,069
Storing an array in a cell Blue Max	by Blue Max	9	648
Sumif function with two criterias ABRAR	by Jarek Kujawa[_2_]	4	464
Demerge cells and copy data Johan	by Ashish Mathur[_2_]	5	2,254
Data Validation - copy paste ! Christoffer Bloch Andersen	by xmux	1	553
find in reverse smw	by jaf	10	1,059
Count Cell that contain a word. Sampoerna	by Sampoerna	11	1,111
countif function: how to distinguish case/make case sensitive mvwoolner	by Shane Devenshire	3	3,504
Copy Down Yrrep	by Dave Peterson	4	497
can i add a header to my table? [email protected]	by Gord Dibben	3	378
help me :( Chris N	by Shane Devenshire	2	308
Excel'de metin iÃ§inden kelime alma GÃ¼rcan CAVLAK	by Shane Devenshire	1	1,555
What is this, #### and what do I do with it? Chestnut	by Gord Dibben	3	338