Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 2002 - Make a List
- Thread starter BellKev
- Start date
AnotherHiggins
Technical User
Data > Filter > Advanced Filter Tick the box beside Unique records only. This will give you each name listed only once.
Now highlight that column and go to Edit > Goto Click on Special then tick the box beside Visible Cells Only. Now only those unique names are selected.
Copy 'n' Paste to another row. Go to Data > Filter > Show All.
[tt]_____
[blue]-John[/blue][/tt]
"Patriotism is your conviction that this country is superior to all other countries because you were born in it."
[tab]-George Bernard Shaw
Help us help you. Please read FAQ181-2886 before posting.
Now highlight that column and go to Edit > Goto Click on Special then tick the box beside Visible Cells Only. Now only those unique names are selected.
Copy 'n' Paste to another row. Go to Data > Filter > Show All.
[tt]_____
[blue]-John[/blue][/tt]
"Patriotism is your conviction that this country is superior to all other countries because you were born in it."
[tab]-George Bernard Shaw
Help us help you. Please read FAQ181-2886 before posting.
- Status