Mar 25 2021 04:08 AM
Mar 25 2021 04:15 AM
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:
Fill down as far as you want.
Mar 25 2021 05:20 AM
Jun 08 2021 06:30 PM - edited Jun 08 2021 06:35 PM
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)
At first, it didn't work. I had to clear my filter for the Advanced Filter use all the data in the array.