Filtering a list

[zwg]

Hello Excel Gurus!

I have a list of 100 names, some repeat. I need a formula that will allow me to extract each name only once.

Any help is greatly appreciated!

Thank you!

 

[Sahak]

Hi,

Try this:

Data > Filter > Advanced Filter
Select: "Copy to another location"
Check: "Unique records only"
Assign your list range to "List range" (for example A1:A20)
Assign range to be extracted to "Copy To: " (for example D1:D1)

 

[AlphaFrog]

Here is a way to do it with a formula...
List Functions

 

[zwg]

Thank you!