Displaying only unique values, PLEASE HELP

J

jezzica85

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!
 
C

cvolkert

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
 
J

jezzica85

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?
 
P

Pete_UK

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
 
Top