I know this is a relatively simple formula but my brain is just not clicking for some reason.
In column A I have a bunch of names.
Jane Smith
Joe Smith
Jane Smith
Joe Dover
Jane Dover
Don Smith
Joe Smith
Jane Dover
In column B, I want it to show unique values and skipping the duplicates. I want it to a dynamic setup where it'll only pull 1 unique value and skip the duplicate names.
Jane Smith
Joe Smith
Joe Dover
Jane Dover
Done Smith
etc
etc
Thank you everyone!
Bookmarks