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!
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!