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?
Let's say that your list of names is in A2:A100, and that you want to extract the unique names into cell D2 and down.
Enter the following formula in D2 and confirm it with Ctrl+Shift+Enter to save it as an array formula:
=IFERROR(INDEX($A$2:$A$100,MATCH(0,COUNTIF(D$1:D1,$A$2:$A$100),0)),"")
Fill down as far as you want.
Is there a way to just copy the list showing up in the filter drop down list?
No, there isn't