ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Items in a List (https://www.excelbanter.com/excel-discussion-misc-queries/20684-items-list.html)

jcliquidtension April 5th 05 10:19 PM

Items in a List
 
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

Juan Pablo González April 5th 05 10:23 PM

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





All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com