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,564
how to return mulitple corresponding values ( 1 2) MetricsShiva	by ExcelBanter AI	70	8,566
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,069
How can I lookup when match has more than one value? ( 1 2) bonot1	by ExcelBanter AI	56	11,838
Can you AVERAGE IF and not null? ( 1 2) Spottkitty	by ExcelBanter AI	52	8,423
Drop Downs, Index Match or what? ( 1 2) Claus Busch	by [email protected]	48	5,937
Incorporating Cell color fill in an "if" logical function? ( 1 2) George_Sky	by ExcelBanter AI	46	12,013
Random Numbers ( 1 2) Steved	by RagDyeR	44	4,573
How can I count items in a filtered list? ( 1 2) Counting filtered data.	by ExcelBanter AI	44	13,588
Blinking Text ( 1 2) Esra Dekan	by Gord Dibben	43	5,356
Sum based on specific condition ( 1 2) Wendy	by Harlan Grove[_2_]	43	5,988
Date fomula not working ( 1 2) FangYR	by Max	43	4,413
How can I make a drop down box visible within a worksheet? ( 1 2) skittles_golf	by ExcelBanter AI	42	10,373
Formula to Return the next 1st Tuesday of a Month ( 1 2) Sean	by Sean	42	5,984
help on averaging function ( 1 2) Treesy	by Harlan Grove[_4_]	41	4,611
In Excel, conditional format (font red) referencing another cell? Christine Hemphill	by Jamie	39	5,397
How do I set up a formula to add column a if column b = cell c1? michelle	by Bernard Liengme[_2_]	38	4,889
A ? for our Excel Guru's and MVPs 4pinoy	by 4pinoy	38	4,935
Counting Unique Values Bob	by Jamie Collins	38	5,244
If/Then Formulas Bk Goto	by John C[_2_]	38	4,154
Frank Kabel: A Sad Day for the Excel Community Norman Harker	by John	38	4,744
SUMPRODUCT and "--" Michelle	by rock star	37	2,370
Simplify formula Luke	by Harlan Grove	37	5,024
How Do You Stop Annoying Excel Message Boxes? Colin Hayes	by Colin Hayes	36	3,719
VBA Question carl	by Gord Dibben[_2_]	36	3,393
Text manipulation paulinoluciano	by paulinoluciano	36	2,183
Return Unquie Values Javier Diaz[_2_]	by Harlan Grove[_2_]	35	1,927
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	8,316
Count Functions TSNS	by Alan Beban[_2_]	34	2,125
Number of years, months, days between two dates. Bluenose	by Grizzly Bear	34	4,373
Counting # of days between 2 dates excluding Fri & Sat) Khaledity	by Jacob Skaria	33	2,735
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com	by Max	33	5,200
Macro for detect palindromes and repeats in letters/numbers string Luciano Paulino da Silva	by Luciano Paulino da Silva	33	2,395
Multiple Item Lookup Chad F	by Chad F[_2_]	33	2,262
How do I caluclate an Annual Percentage Rate in Excel? Lisa M	by ExcelBanter AI	32	9,457
Reverse PRICE function ingmar	by John C[_2_]	32	3,094
SUMIF or SUMPRODUCT to total cells containing multiple texts Terranoman	by Terranoman	31	2,875
Using COUNTIF to search for existence Epinn	by Epinn	31	3,347
Sumif / Countif - Not certain - want to extract data from cell and M.A. Clark	by Bob Phillips	30	1,969
sumif maybe? Esradekan	by Don Guillett	30	1,757
convert meters to feet/inches Ann	by ExcelBanter AI	30	10,629
Non updatable Unique Random Number Ian	by Ian	30	3,596
date criteria to select range Kstalker	by Max	30	2,641
If And Help? [email protected]	by [email protected]	30	1,745
SIMPLE CONCATENATE FUNCTION Rebecca	by Tom	30	1,916
With a Function, how can I get rid of formating codes like <div ? AFSSkier	by Ron Rosenfeld	30	1,711
Counting odd & even #s Ed	by Ron Rosenfeld	29	1,343
Color Cells Summing HANYANA	by Max	29	2,406
Cell validation Sai Krishna[_2_]	by isabelle	29	2,684
Convert variable #'s in a gen. format to a # that can be used w/ma Steve	by T. Valko	29	1,561
Help with MID Function? KLZA	by Ron Rosenfeld	28	1,500
extracting numbers cj	by Ron Rosenfeld	28	1,586
Rule of 75 Retirement Calculation BAD	by ExcelBanter AI	28	11,593
insert date Larry	by CLR	28	3,660
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS JingleRock[_2_]	by T. Valko	28	2,796
Counting Unique entry from Concatenated list Rajat	by Rajat	28	1,942
Deleting by date automatically Bryan De-Lara[_2_]	by David Biddulph[_2_]	27	1,389
assigning a unique value Dino	by Harlan Grove	27	2,804
If/Then Statement Karen	by Pete_UK	27	1,165
MATCH Multiple Criteria & Return Previous / Penultimate Match Sam via OfficeKB.com	by Sam via OfficeKB.com	27	3,711
Counting Unique Values RJL0323	by Aladin Akyurek	27	3,199
multiple worksheet help darkbearpooh1	by darkbearpooh1	27	1,724
Array index, match problem RAP	by Alan Beban	27	2,325
How do I link cells from one excel worksheet to another? stb	by Buckeroo	27	4,292
Average of top 3 numbers. Belzbub	by Ron Coderre	26	1,799
NETWORKDAYS calc with 3 columns of dates Mendz5	by Bob Phillips	26	1,934
ALTERNATIVE TO SUMPRODUCT NEEDED Rog	by Rog	26	1,876
Excel 2003 SP2 computes the power of a negative number wrong. Giovanni Ciriani	by Roger Govier	26	2,285
INT defect: Please try this on 2007 for me JoeU2004	by Charles Williams	26	1,732
Find value in array Brook6	by Harlan Grove	26	3,471
VBA Code; need linked cells to change color if condition met JVANWORTH	by Dave Peterson	26	3,561
Worksheet Formula Returning Sum of a Series monir	by Dana DeLouis	26	2,162
REPORTING unique values jane	by Blue Max	26	1,492
if formula #value dan dungan	by Harlan Grove[_2_]	26	2,606
How to time-limit an Excel file installation Colin Hayes	by Harlan Grove[_2_]	26	1,548