Items in a List

  • Thread starter jcliquidtension
  • Start date
J

jcliquidtension

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
 
J

Juan Pablo González

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