I'm looking for a formula that given Column A filled with names (a lot of them repeating) will return Column B as a list of names with no duplicates. For example:
Column A
John
Juan
Juan
Jose
Jose
Jose
Joseph
Myra
Myra
Lina
Will be:
John
Juan
Jose
Joseph
Myra
Lina
I don't want to use Macro, PT, or the Consolidate function. I already know how to do it with those 3 options. I'm looking for a cell formula. Well, I don't know how to do it in Macro but that will be a future challenge. Thank you
Bookmarks