is there a simple formula that will remove all duplicates

  • Thread starter Thread starter john
  • Start date Start date
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!
 
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
 
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 -
Click to expand...

THANK YOU , THAT WORKED GREAT!!!!!
 
Back
Top