software

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--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: www.excelforum.com/member.php...oamp;userid=24380
View this thread: www.excelforum.com/showthread...hreadid=515179Hi, 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?

quot;cvolkertquot; wrote:

gt;
gt; One way to do what you are asking is to create a pivot table on the
gt; data. If you drag the desired column into the left column of the pivot
gt; table format, it will only pick up unique values. let me know if you
gt; need more details. The wizard is pretty good for pivot tables. Later
gt; - Chad
gt;
gt;
gt; --
gt; cvolkert
gt; ------------------------------------------------------------------------
gt; cvolkert's Profile: www.excelforum.com/member.php...oamp;userid=24380
gt; View this thread: www.excelforum.com/showthread...hreadid=515179
gt;
gt;

You can use Data | Filter | Advanced filter to get unique values only -
tick this option, and you may also want to tick quot;Copy to new locationquot;
and specify a cell in another sheet, so that you still have your
original data.

Hope this helps.

Pete