Items in a List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use Filter | Advanced Filter, and check the 'Unique records' box. You can
copy the results to another location too.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting Blank rows between items 6
Reading a list of names to update their records 1
Quick Pivot Table Question 2
Master data seen on 3 tabs. 2
Duplicate a set of rows for each item (subdatasheet?) 0
Match Email address to Filenames in a list and Send Email As Attachment 2
Repeat Pivot Row on when printing 1
Subtotal To Include Item Description On Subtotal Line 2

Back
Top