Posted to microsoft.public.excel.worksheet.functions

Bruce

Posts: n/a

Countif unique

How do i count unique values in my data?

Eg A1:A5
Red
Blue
Yellow
Blue
Red

=3

Bruce

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
code not unique find latest date	Barbara Wiseman	Excel Discussion (Misc queries)	3	December 11th 05 08:50 AM
COUNTIF or not to COUNTIF on a range in another sheet	Ellie	Excel Worksheet Functions	4	September 15th 05 10:06 PM
Count Unique Values	annie	Excel Worksheet Functions	1	June 9th 05 07:19 AM
Combining IF and COUNTIF based on two columns	maxtrixx	Excel Discussion (Misc queries)	5	March 31st 05 06:21 PM
Countif - Countif	maswinney	Excel Worksheet Functions	3	November 15th 04 11:06 PM

All times are GMT +1. The time now is 09:56 PM.

About Us

"It's about Microsoft Excel"