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?
I was facing the same issue and this video helped me get my desired result:
Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria)
https://youtu.be/_KGqJLXJvgY
At first, it didn't work. I had to clear my filter for the Advanced Filter use all the data in the array.
Cheers!
Mark_Azzy Thanks for the tutorial link.
