List out individual names from a list of multiple names

[Ignition1]

So if that title of the thread didn't make any sense...

I have a list of names in Column A -

Tom
Tom
Tom
Tom
George
****
****
Harry
Harry
Harry
Sandra
Sandra
Leon
Paul
Paul
Paul

Etc....

What I would like Excel to do is list out in Column B all the unique names in the list. Is there a formula to do this?

 

[T. Valko]

So if that title of the thread didn't make any sense...

I have a list of names in Column A -

Tom
Tom
Tom
Tom
George
****
****
Harry
Harry
Harry
Sandra
Sandra
Leon
Paul
Paul
Paul

Etc....

What I would like Excel to do is list out in Column B all the unique names in the list. Is there a formula to do this?

You can do this quite easily using the advanced filter. No formulas needed.

What version of Excel are you using?

 

[Ignition1]

Actually...it just dawned on me.

I can use Data - Filter - Advanced Filter - Copy to Range using Unique Entries.

Sorry, please close the thread.

 

[Ignition1]

Just found that as well! Thanks!

 

[T. Valko]

Just found that as well! Thanks!

Good deal. Thanks for the feedback!