Excel Worksheet Functions

Thread / Thread Starter	Last Post	Replies	Views
Can I Use a Count Function for Text? ( 1 2 3) Joan NYC	by ExcelBanter AI	107	11,570
how to return mulitple corresponding values ( 1 2) MetricsShiva	by ExcelBanter AI	70	8,575
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches ( 1 2) [email protected]	by ExcelBanter AI	66	9,077
How can I lookup when match has more than one value? ( 1 2) bonot1	by ExcelBanter AI	56	11,842
Can you AVERAGE IF and not null? ( 1 2) Spottkitty	by ExcelBanter AI	52	8,433
Drop Downs, Index Match or what? ( 1 2) Claus Busch	by [email protected]	48	5,941
Incorporating Cell color fill in an "if" logical function? ( 1 2) George_Sky	by ExcelBanter AI	46	12,019
Random Numbers ( 1 2) Steved	by RagDyeR	44	4,576
How can I count items in a filtered list? ( 1 2) Counting filtered data.	by ExcelBanter AI	44	13,605
Blinking Text ( 1 2) Esra Dekan	by Gord Dibben	43	5,360
Sum based on specific condition ( 1 2) Wendy	by Harlan Grove[_2_]	43	5,995
Date fomula not working ( 1 2) FangYR	by Max	43	4,415
How can I make a drop down box visible within a worksheet? ( 1 2) skittles_golf	by ExcelBanter AI	42	10,403
Formula to Return the next 1st Tuesday of a Month ( 1 2) Sean	by Sean	42	5,987
help on averaging function ( 1 2) Treesy	by Harlan Grove[_4_]	41	4,615
In Excel, conditional format (font red) referencing another cell? Christine Hemphill	by Jamie	39	5,399
How do I set up a formula to add column a if column b = cell c1? michelle	by Bernard Liengme[_2_]	38	4,890
A ? for our Excel Guru's and MVPs 4pinoy	by 4pinoy	38	4,936
Counting Unique Values Bob	by Jamie Collins	38	5,246
If/Then Formulas Bk Goto	by John C[_2_]	38	4,155
Frank Kabel: A Sad Day for the Excel Community Norman Harker	by John	38	4,745
SUMPRODUCT and "--" Michelle	by rock star	37	2,372
Simplify formula Luke	by Harlan Grove	37	5,026
How Do You Stop Annoying Excel Message Boxes? Colin Hayes	by Colin Hayes	36	3,720
VBA Question carl	by Gord Dibben[_2_]	36	3,396
Text manipulation paulinoluciano	by paulinoluciano	36	2,185
Return Unquie Values Javier Diaz[_2_]	by Harlan Grove[_2_]	35	1,930
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	8,318
Count Functions TSNS	by Alan Beban[_2_]	34	2,126
Number of years, months, days between two dates. Bluenose	by Grizzly Bear	34	4,375
Counting # of days between 2 dates excluding Fri & Sat) Khaledity	by Jacob Skaria	33	2,736
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com	by Max	33	5,202
Macro for detect palindromes and repeats in letters/numbers string Luciano Paulino da Silva	by Luciano Paulino da Silva	33	2,396
Multiple Item Lookup Chad F	by Chad F[_2_]	33	2,263
How do I caluclate an Annual Percentage Rate in Excel? Lisa M	by ExcelBanter AI	32	9,461
Reverse PRICE function ingmar	by John C[_2_]	32	3,095
SUMIF or SUMPRODUCT to total cells containing multiple texts Terranoman	by Terranoman	31	2,876
Using COUNTIF to search for existence Epinn	by Epinn	31	3,349
Sumif / Countif - Not certain - want to extract data from cell and M.A. Clark	by Bob Phillips	30	1,971
sumif maybe? Esradekan	by Don Guillett	30	1,758
convert meters to feet/inches Ann	by ExcelBanter AI	30	10,631
Non updatable Unique Random Number Ian	by Ian	30	3,598
date criteria to select range Kstalker	by Max	30	2,642
If And Help? [email protected]	by [email protected]	30	1,746
SIMPLE CONCATENATE FUNCTION Rebecca	by Tom	30	1,917
With a Function, how can I get rid of formating codes like <div ? AFSSkier	by Ron Rosenfeld	30	1,712
Counting odd & even #s Ed	by Ron Rosenfeld	29	1,344
Color Cells Summing HANYANA	by Max	29	2,410
Cell validation Sai Krishna[_2_]	by isabelle	29	2,686
Convert variable #'s in a gen. format to a # that can be used w/ma Steve	by T. Valko	29	1,563
Help with MID Function? KLZA	by Ron Rosenfeld	28	1,501
extracting numbers cj	by Ron Rosenfeld	28	1,588
Rule of 75 Retirement Calculation BAD	by ExcelBanter AI	28	11,625
insert date Larry	by CLR	28	3,664
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS JingleRock[_2_]	by T. Valko	28	2,797
Counting Unique entry from Concatenated list Rajat	by Rajat	28	1,943
Deleting by date automatically Bryan De-Lara[_2_]	by David Biddulph[_2_]	27	1,390
assigning a unique value Dino	by Harlan Grove	27	2,805
If/Then Statement Karen	by Pete_UK	27	1,166
MATCH Multiple Criteria & Return Previous / Penultimate Match Sam via OfficeKB.com	by Sam via OfficeKB.com	27	3,712
Counting Unique Values RJL0323	by Aladin Akyurek	27	3,200
multiple worksheet help darkbearpooh1	by darkbearpooh1	27	1,725
Array index, match problem RAP	by Alan Beban	27	2,326
How do I link cells from one excel worksheet to another? stb	by Buckeroo	27	4,293
Average of top 3 numbers. Belzbub	by Ron Coderre	26	1,800
NETWORKDAYS calc with 3 columns of dates Mendz5	by Bob Phillips	26	1,935
ALTERNATIVE TO SUMPRODUCT NEEDED Rog	by Rog	26	1,877
Excel 2003 SP2 computes the power of a negative number wrong. Giovanni Ciriani	by Roger Govier	26	2,286
INT defect: Please try this on 2007 for me JoeU2004	by Charles Williams	26	1,733
Find value in array Brook6	by Harlan Grove	26	3,473
VBA Code; need linked cells to change color if condition met JVANWORTH	by Dave Peterson	26	3,562
Worksheet Formula Returning Sum of a Series monir	by Dana DeLouis	26	2,163
REPORTING unique values jane	by Blue Max	26	1,493
if formula #value dan dungan	by Harlan Grove[_2_]	26	2,607
How to time-limit an Excel file installation Colin Hayes	by Harlan Grove[_2_]	26	1,549