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.
I have used your formula but i am getting the list with repeating values. I need all values without any duplicates
I am getting like below
Plant
Plant
Plant
Plant
Site
...
I need like below
Plant
Site
...
I am getting like below
Plant
Plant
Plant
Plant
Site
...
I need like below
Plant
Site
...
Strange - it should work.
Do you have Microsoft 365? If so, you can use the new UNIQUE function - see Excel UNIQUE Function