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 was use sort the column list to be the names that I wanted.
Then I highlighted the column with the names and clicked on remove duplicates on the Data tab.
This left just the names that I wanted. So I just highlighted the column and copied them. After which you can just undo the previous changes. Bit of a workaround but whatever it worked.