Excel Worksheet Functions - Page 4

Thread / Thread Starter	Last Post	Replies	Views
"COUNTU" function in Excel to count unique entries in a range WayneL	by T. Valko	20	5,795
sum of a named range with values based on vlookup results Solutions Manager	by T. Valko	20	1,846
Excel Count Functions Gasbag	by Rick Rothstein	20	1,565
Looking for a better solution ibvalentine	by T. Valko	20	1,571
How to omit blank cells when calculating weighted averages Suzy	by T. Valko	20	2,234
Count and Sum functions with 2 criterias Sue	by Sandy Mann	20	1,115
significant digits Gordon[_2_]	by Bernd P	20	1,445
IS A TIME BETWEEN TWO TIMES EG 12:00 & 8:00 Shirley4589	by Sandy Mann	20	1,852
How do i find a sequence LiAD	by LiAD	20	1,295
Counting Items Jakobshavn Isbrae	by Harlan Grove[_2_]	20	1,341
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,495
Formula won't show sum Parry	by Dennis (The Menace) Hayden[_2_]	20	2,774
Rounding to nearest 9 GaryS	by Rick Rothstein \(MVP - VB\)[_626_]	20	3,141
how to remove #n/a error in excel vlookup b/c value is not found? B. Franklin Saunders	by ExcelBanter AI	20	8,425
IRR gotahavit	by Ron Rosenfeld	20	1,884
Cell referncing heather	by heather	20	1,406
Create Acronym (Extract first letter of each word) VB_Sam	by ExcelBanter AI	20	8,744
VLOOKUP text vs number issues returning value puck1263	by joeu2004[_2_]	20	4,008
The last day Ron de Bruin	by Billns	20	2,390
calculate percent between 10.0 and 12.0 for data in multiple sheet wissam	by wissam	20	1,798
Vlookup LWilson	by T. Valko	20	1,600
How to find a particular word? Jack	by Ron Rosenfeld	20	1,971
conditional format narp[_2_]	by Domenic[_2_]	20	1,478
Validation List - adding new entries watermt	by Ron Coderre[_3_]	20	1,673
Counting data that meets 3 different Criteria Jenny.S	by Jenny S	20	1,675
building comments from text cells Michael.Tarnowski	by Michael.Tarnowski	20	1,222
Special Paste confusion Nobody[_2_]	by Nobody[_2_]	19	1,204
Sum Count of Numeric Duplicates: appears x2 in any Row Sam via OfficeKB.com	by T. Valko	19	1,293
table formula jeel	by jeel	19	1,158
Best 25 scores..help please Terry	by Terry	19	1,040
inverse of the column function? i.e. input a number, output thecorresponding column text label Brotherharry	by Harlan Grove[_2_]	19	2,456
IF STATEMENT sbain	by Steve Dunn	19	1,490
Help with a formmula change in a "flag" parameter! Danny Boy	by Steve Dunn	19	1,524
Median calculation of grouped data. Bruce	by ExcelBanter AI	19	8,718
OLD PROBLEM without SOLUTION ytayta555	by ytayta555	19	1,053
Countifs with same reference? CEBeau	by David Biddulph[_2_]	19	1,072
extract date from text Woodi2	by Ron Rosenfeld	19	1,219
Sumproduct on filtered cells Ndel40	by Ndel40	19	2,911
multiple ranges, transposing? Mea	by Herbert Seidenberg	19	1,552
Extracting h:mm:ss from text string Micki	by Glenn	19	1,366
Need a formula to give me the last value in a column. SMH	by janabanana	19	1,242
Counting # of Times an Item Shows Up in a Table Ralph	by Aladin Akyurek	19	1,475
Restarting a macro BR	by Dave Peterson	19	1,785
Remove html markup Stuart	by Ron Coderre	19	1,276
How do I calculate if a date is in a certain time frame? Pe66les	by Ron Rosenfeld	19	2,754
shading different rows when a value changes in col. Linc	by Linc	19	1,923
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns Sam via OfficeKB.com	by Sam via OfficeKB.com	19	1,915
column variables mahmon	by Ron Rosenfeld	19	944
How can I sort SSNs in Terminal Digit Order using Excel? postitnote	by RagDyer	19	3,822
referencing named formula using INDIRECT function [email protected]	by Rob Hick	19	3,193
Hiding cells on condition Pennington	by William	19	1,448
Array functions ARGHH! Marc Fleury	by Wazooli	19	1,325
Averaging noncontiguous numbers ignoring zeros? Mike	by Myrna Larson	19	2,167
How do I count shaded cells Randy	by Randy	19	3,357
excel formulas Tomas	by ELOGEE	19	1,003
vlookup for same name, multiple instances... Chris_Hatch	by Pete_UK	19	2,763
Formula is driving me crazy????? Chris Watson	by Sandy Mann	19	1,416
Function/ formula to output a cell reference Creator	by Sandy Mann	19	1,749
How do I link mulitple drop down boxes together? Misty	by BigPig	19	1,583
Do not allow Narrow Down with AutoFilter [email protected]	by [email protected]	19	1,015
Counting unique items based on date DKS	by Ron Coderre	19	1,398
Excel Function IF AND Indigo	by Indigo	19	1,101
How to return multiple cells from a data sheet in a seperate workbook [email protected]	by [email protected]	19	1,325
CheckBoxes Stack up when Rows are hidden and unhidden Goldenfoot	by Dave Peterson	19	2,040
Harlan Grove PULL Code Help Please deeds	by pat henriquez	19	4,062
And, if, arguments.... Chuck_in_Mo	by Chuck_in_Mo	19	1,227
Compare columns, count matches adodson	by T. Valko	19	3,969
Calculating values from multiplesheets with multiple criteria I have no idea	by Barb Reinhardt	19	1,675
can vlookup look up the result of a function? fryguy	by JMB	19	923
Data collation killing me!! rhani111	by rhani111	19	974
find hidden data in worksheet catlover1946	by catlover1946	19	2,340
Matching Text with With Certain Criteria SteveC	by Max	19	1,900
Finding email addresses in cells Joey	by Harlan Grove	19	1,424
Price Code Help Please natei6	by Roger Govier	19	951
Time format help needed Dan W.	by David Biddulph[_2_]	19	2,764