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,653
how to return mulitple corresponding values ( 1 2) MetricsShiva	by ExcelBanter AI	70	8,767
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,138
How can I lookup when match has more than one value? ( 1 2) bonot1	by ExcelBanter AI	56	11,925
Can you AVERAGE IF and not null? ( 1 2) Spottkitty	by ExcelBanter AI	52	8,595
Drop Downs, Index Match or what? ( 1 2) Claus Busch	by [email protected]	48	6,006
Incorporating Cell color fill in an "if" logical function? ( 1 2) George_Sky	by ExcelBanter AI	46	12,088
How can I count items in a filtered list? ( 1 2) Counting filtered data.	by ExcelBanter AI	44	13,760
Random Numbers ( 1 2) Steved	by RagDyeR	44	4,596
Date fomula not working ( 1 2) FangYR	by Max	43	4,433
Sum based on specific condition ( 1 2) Wendy	by Harlan Grove[_2_]	43	6,112
Blinking Text ( 1 2) Esra Dekan	by Gord Dibben	43	5,397
How can I make a drop down box visible within a worksheet? ( 1 2) skittles_golf	by ExcelBanter AI	42	10,903
Formula to Return the next 1st Tuesday of a Month ( 1 2) Sean	by Sean	42	6,013
help on averaging function ( 1 2) Treesy	by Harlan Grove[_4_]	41	4,638
In Excel, conditional format (font red) referencing another cell? Christine Hemphill	by Jamie	39	5,408
If/Then Formulas Bk Goto	by John C[_2_]	38	4,159
A ? for our Excel Guru's and MVPs 4pinoy	by 4pinoy	38	4,954
Counting Unique Values Bob	by Jamie Collins	38	5,258
How do I set up a formula to add column a if column b = cell c1? michelle	by Bernard Liengme[_2_]	38	4,910
Frank Kabel: A Sad Day for the Excel Community Norman Harker	by John	38	4,757
SUMPRODUCT and "--" Michelle	by rock star	37	2,383
Simplify formula Luke	by Harlan Grove	37	5,038
Text manipulation paulinoluciano	by paulinoluciano	36	2,191
VBA Question carl	by Gord Dibben[_2_]	36	3,417
How Do You Stop Annoying Excel Message Boxes? Colin Hayes	by Colin Hayes	36	3,725
Return Unquie Values Javier Diaz[_2_]	by Harlan Grove[_2_]	35	1,931
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	8,350
Count Functions TSNS	by Alan Beban[_2_]	34	2,129
Number of years, months, days between two dates. Bluenose	by Grizzly Bear	34	4,420
Macro for detect palindromes and repeats in letters/numbers string Luciano Paulino da Silva	by Luciano Paulino da Silva	33	2,402
Multiple Item Lookup Chad F	by Chad F[_2_]	33	2,269
Counting # of days between 2 dates excluding Fri & Sat) Khaledity	by Jacob Skaria	33	2,744
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com	by Max	33	5,287
How do I caluclate an Annual Percentage Rate in Excel? Lisa M	by ExcelBanter AI	32	9,537
Reverse PRICE function ingmar	by John C[_2_]	32	3,096
Using COUNTIF to search for existence Epinn	by Epinn	31	3,353
SUMIF or SUMPRODUCT to total cells containing multiple texts Terranoman	by Terranoman	31	2,879
Non updatable Unique Random Number Ian	by Ian	30	3,612
If And Help? [email protected]	by [email protected]	30	1,752
convert meters to feet/inches Ann	by ExcelBanter AI	30	10,658
date criteria to select range Kstalker	by Max	30	2,653
sumif maybe? Esradekan	by Don Guillett	30	1,767
Sumif / Countif - Not certain - want to extract data from cell and M.A. Clark	by Bob Phillips	30	1,977
With a Function, how can I get rid of formating codes like <div ? AFSSkier	by Ron Rosenfeld	30	1,719
SIMPLE CONCATENATE FUNCTION Rebecca	by Tom	30	1,929
Convert variable #'s in a gen. format to a # that can be used w/ma Steve	by T. Valko	29	1,602
Counting odd & even #s Ed	by Ron Rosenfeld	29	1,345
Cell validation Sai Krishna[_2_]	by isabelle	29	2,695
Color Cells Summing HANYANA	by Max	29	2,440
extracting numbers cj	by Ron Rosenfeld	28	1,593
Help with MID Function? KLZA	by Ron Rosenfeld	28	1,502
Rule of 75 Retirement Calculation BAD	by ExcelBanter AI	28	11,875
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS JingleRock[_2_]	by T. Valko	28	2,798
Counting Unique entry from Concatenated list Rajat	by Rajat	28	1,944
insert date Larry	by CLR	28	3,765
How do I link cells from one excel worksheet to another? stb	by Buckeroo	27	4,300
multiple worksheet help darkbearpooh1	by darkbearpooh1	27	1,734
Array index, match problem RAP	by Alan Beban	27	2,335
Deleting by date automatically Bryan De-Lara[_2_]	by David Biddulph[_2_]	27	1,392
Counting Unique Values RJL0323	by Aladin Akyurek	27	3,205
assigning a unique value Dino	by Harlan Grove	27	2,814
MATCH Multiple Criteria & Return Previous / Penultimate Match Sam via OfficeKB.com	by Sam via OfficeKB.com	27	3,723
If/Then Statement Karen	by Pete_UK	27	1,172
INT defect: Please try this on 2007 for me JoeU2004	by Charles Williams	26	1,736
Formula than understands midnight? Auric__	by Auric__	26	2,488
if formula #value dan dungan	by Harlan Grove[_2_]	26	2,612
How to time-limit an Excel file installation Colin Hayes	by Harlan Grove[_2_]	26	1,551
REPORTING unique values jane	by Blue Max	26	1,496
ALTERNATIVE TO SUMPRODUCT NEEDED Rog	by Rog	26	1,879
Excel 2003 SP2 computes the power of a negative number wrong. Giovanni Ciriani	by Roger Govier	26	2,296
Find value in array Brook6	by Harlan Grove	26	3,510
NETWORKDAYS calc with 3 columns of dates Mendz5	by Bob Phillips	26	1,942
Average of top 3 numbers. Belzbub	by Ron Coderre	26	1,800
How do I remove the #div or N/A and make it 0 when using VLookup? JeaneIsaac	by Flcnmech	26	5,125