Displaying only unique values, PLEASE HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
One way to do what you are asking is to create a pivot table on the
data. If you drag the desired column into the left column of the pivot
table format, it will only pick up unique values. let me know if you
need more details. The wizard is pretty good for pivot tables. Later
- Chad
 
Hi, I tried that, and it didn't alphabetize the words right, left some out,
and made some duplicates. Is there a different way, or better yet a way to
go through the whole sheet and just list the unique words so I don't have to
go through 31 columns?
 
You can use Data | Filter | Advanced filter to get unique values only -
tick this option, and you may also want to tick "Copy to new location"
and specify a cell in another sheet, so that you still have your
original data.

Hope this helps.

Pete
 
Back
Top