How to copy the filter list in excel

What i did to tackle this challenge was:

- copy the column itself ,

- then pasted in a new excel spreadsheet

 - In the new excel spreadsheet, select this column

- go to Data tab, then select remove duplicates.

after that you can the copy the unique names.

seestep 4step 3step 2Step 1 snapshots of the steps.

hope someone else finds this helpful.

ravikumarnv60 

ravikumarnv60 

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. 

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!

ravikumarnv60 

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.