Check if a name is present in several columns

Marcus Coates

New member
Joined
Sep 11, 2012
Messages
12
Reaction score
0
Points
0
Hi I want a way to check that a persons name is not listed in more than one column. So I have several columns with names. A persons name must be in 2 columns. How can I set up a formula or formatting to check several columns and tell me who has only got their name entered once?
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
You can select the range.... Assuming A2: D100, then go to Home|Conditional Formatting, New Rule.

Select "use a formula to determine which cells to format"

Then enter formula:

=COUNTIF($A$2:$D$100,A2)=1

Click format and choose from Fill tab.
 
Top