Forum Discussion
How to copy the filter list in excel
I have an excel with list of names. I want to copy the unique names. To get unique names, I am using filters. Now how can copy the names showing up in filters drop down list?
What i did to tackle this challenge was:
- copy the column itself ,
- then pasted in a new excel spreadsheet
- In the new excel spreadsheet, select this column
- go to Data tab, then select remove duplicates.
after that you can the copy the unique names.
seestep 4step 3step 2Step 1 snapshots of the steps.
hope someone else finds this helpful.