is there a simple formula that will remove all duplicates in a simple list

J

john

is there a simple formula that will remove all duplicates in a simple
list? I have a list of names going down column A. Sometimes the name
appears again further down the list. I could do a "sort" and look for
doubles but that would be a pain. There must be a formula I can past
in colum b which would show blanks wherever a duplicate appeared.
Thanks in advance for any help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top