Remove duplicates in column to count specifics

[afdmello]

Hi all,

I have 400 rows of data in a column which are also repeat and so I want to remove the duplicates or hide them so I can count the unique entries. Is there an easy and quick way?

Thanking you,

Afd

 

[jasonb75]

You could use the =UNIQUE function to count the unique entries without removing or hiding the duplicates.

 

[afdmello]

I do not have the unique function. I use excel 2016. The intent is only to count and nothing else.

Thanks Though.

 

[jasonb75]

Based on a single column, or multiple columns?
The simplest method that comes to mind is

=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

However that is only good for a single row or column with no empty cells in the specified range.

 

[Kerryx]

Or put into a pivot table and use the filter to count unique values, its a fine solution for something you don't have to do all the time