is there a simple formula that will remove all duplicates

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

 

[Pete_UK]

Try this in B1:

=IF(COUNTIF(A$1:A1,A1)=1,A1,"")

and copy down. This will copy the name into column B for the first
occurrence and leave column B blank for multiple occurrences.

Hope this helps.

Pete

 

[john]

Try this in B1:

=IF(COUNTIF(A$1:A1,A1)=1,A1,"")

and copy down. This will copy the name into column B for the first
occurrence and leave column B blank for multiple occurrences.

Hope this helps.

Pete



- Show quoted text -

THANK YOU , THAT WORKED GREAT!!!!!

 

[Pete_UK]

You're welcome, John - thanks for feeding back.

Pete