View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jezzica85
 
Posts: n/a
Default Displaying only unique values, PLEASE HELP

Hi all,
Is there any way to format a worksheet so only unique data is shown in it?
Basically, if there are many of the same word in a column, is it possible to
delete all of them except one, without going through the whole column, so
there's only one of each word, and then sort them so they're alphabetical?
Thanks!