How do I set up a formula to count only unique items in a column?

Posted to microsoft.public.excel.worksheet.functions

jennifer

Posts: n/a

How do I set up a formula to count only unique items in a column?

I take no credit; Not my creation:

=SUMPRODUCT((A1:A30<"")/COUNTIF(A1:A30,A1:A30&""))
or
=SUMPRODUCT(--(A1:A30<""),1/COUNTIF(A1:A30,A1:A30&""))

"LYLERR" wrote:

For Example: If I have a column with 8 items but two are duplicates. I want
the formula to return a value of only the unique items (6)

ABC
DEF
GHI
JKL
MNO
PQR
ABC
DEF

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
count unique items in ever-growing list?	MeatLightning	Excel Discussion (Misc queries)	2	March 17th 06 06:07 PM
How do I set up a formula to count multiple items?	Mikaka	Excel Worksheet Functions	4	January 23rd 06 06:27 AM
count unique with conditions	\ditzman via OfficeKB.com\	Excel Worksheet Functions	8	July 8th 05 12:41 PM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	0	May 15th 05 08:14 PM
Count number of unique items in a column that contains duplicates	Steembeem	Excel Worksheet Functions	3	February 2nd 05 12:51 AM

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

Menu

About Us