Contact list clean-up

Copper Contributor

I have a contact list with 700+ with columns for FirstName, LastName and Email. This is a growing list. I need to assure new entries are not repeats of previous entries.  How can I highlight repeat inputs?

1 Reply

@Pat_RyanPat_Ryan790 

=COUNTIFS($A$2:$A$2600,$A2,$B$2:$B$2600,$B2,$C$2:$C$2600,$C2)>1

 

If you data is in range A2:C2600 you can enter above rule for conditional formatting in order to highlight double entries as shown in the attached file.