View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sephiroths816@gmail.com is offline
external usenet poster
 
Posts: 22
Default Filtering diverse values

I'm trying to filter out diverse values in a column

Assume:
A1:A5 = Name1
A6:A10 = Name2
A11:A15 = Name3

I want to be able to automate a list that shows:

Name1
Name2
Name3

Not:

Name1
Name1
Name1
Name1
Name1
Name2
Name2
Name2
Name2
Name2
Name3
Name3
Name3
Name3
Name3

I have an idea of how to do this, but I want to make sure if I'm even
thinking in the right direction.