Use Filter | Advanced Filter, and check the 'Unique records' box. You can
copy the results to another location too.

--
Regards,

Juan Pablo González
Excel MVP

"jcliquidtension" wrote in
message ...
Hi,

If I have a list with numerous items, most of which are repeated a number
of
times, how can I create a list that shows each item in the larger list
once?

For example,

from this list:
John
John
John
James
James
Tom
Tom
Tom
Tom

I'd like to get:
John
James
Tom

Is there an easier way of doing this than creating a pivot table, or using
subtotals?

Thanks,
Jason