Thread: Get number of different values in a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claus[_3_] Claus[_3_] is offline
external usenet poster
  
Posts: 40
Default 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


Reply With QuoteReply With Quote