Get number of different values in a column
 

Hi

How do i get the number of different value in a column with for example 100
rows where a number of rows have the same value.

Example
Column:

Sam
Tom
Sam
Pete
Pete

Result:
Sam
Tom
Pete

Autofilter is not an option.

Regards,
Claus

Get number of different values in a column
 

Use Advanced filter which has a Unique option. It can copy you list of
unique values to another location.

Data=Filter=Advanced Filter.
--
Regards,
Tom Ogilvy

"Claus" wrote in message
...
Hi

How do i get the number of different value in a column with for example
100
rows where a number of rows have the same value.

Example
Column:

Sam
Tom
Sam
Pete
Pete

Result:
Sam
Tom
Pete

Autofilter is not an option.

Regards,
Claus