Generate list

[R4ym0nd]

I have a spreasheet with over 25000 records, in one of the columns I have the
salesperson's name. There are over 60 different names in that column.
Is there a way (apart from creating a pivot table) that excel can generate a
list of the names contained in that column?
Basically what I'm asking is if it's possible to convert the "autofilter"
content into a list...

 

[Ron de Bruin]

Hi R4ym0nd

Use Advanced filter
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[Klemen25]

Hello
If I understand you, than try advanced filter and filter using unique
records.

See here:
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[R4ym0nd]

Thank you both, that's exactly what I was looking for.

 

[Shane Devenshire]

Hi,

Here is a different way in 2007

1. Copy the list to blank column
2. Select it and choose Data, Remove Duplicates (just for the selected
column).