Generate list

  • Thread starter Thread starter R4ym0nd
  • Start date Start date
R

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...
 
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).
 
Back
Top