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 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