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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I set up a formula to count only unique items in a column? (https://www.excelbanter.com/excel-worksheet-functions/79712-re-how-do-i-set-up-formula-count-only-unique-items-column.html)

jennifer

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

All times are GMT +1. The time now is 04:47 AM.