View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Brian is offline
external usenet poster
 
Posts: 38
Default Formula (not adv. filter) to list unique values from list

Howdy all,

I have a list of names which appear multiple times in a column with about
20,000 entries.

I want to create a list of the unique names on a new sheet, but I don't want
to use the advanced filter technique because I want to be able to refresh
this list when new data is entered.

Thanks for your time and attention!

Brian