ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.

Incidently, this is exactly the answer I gave to a posting just a few days
ago. You can often find answers to your questions by searching in the forum
-- also easy as pie: Just type a key word like "duplicates" in the search box
above.

Hi JW

There are 2 ways you can do this.

Either put your list into a pivot table which will condolidate it for you,
then copy the results and paste special values

or

(once the list is sorted alphbetically) put a simple forumla in the column
next to your list of
=(A1=A2)

This will give you a result of TRUE if the cells are the same or FALSE if
they are not.  Copy the new column and paste special values and sort by your
new column.

Delete all of the TRUE's which will leave you with a unique list.

HTH

Thanks,

Simon

Choose Data|Filter|Advanced Filter with unique records and copy to
another column selected and in the copy to Box select a cell to output
the unique data to.