Finding unique numbers in a column

C

coolkid397

Is there any way to find the number of unique values among a set o
values in a column in an excel sheet. I would also like to know th
number of times each value appears in the column.

Thank
 
T

terabar

There was also a similar thread under Excel Worksheet functions titled
"Delete duplicates".

Solution provided was to use:
Data>Filter>Advanced filter>Copy to another location and unique records
only.

Once u get ur unique numbers in a separate table u can then use
COUNTIF(range,criteria) to count the occurence of each unique number in
the original list.

Cheers.
 
B

Biff

Hi!

Assume your list is in the range A1:A100

Count of uniques:

=SUMPRODUCT((A1:A100 said:
I would also like to know the number of times each value appears in the
column.
Click to expand...

One way to do this:

Use Data>Advanced Filter to copy unique values to another location. Assume
that new location is B1:B10. In C1 enter this formula and copy down to C10:

=COUNTIF(A$1:A$100,B1)

Biff
 
Top