Check and identify duplicate entries

adzygore

New member
Joined
Sep 28, 2012
Messages
1
Reaction score
0
Points
0
I have a data sheet in which I have to check for multiple entries in 2 or more columns. I have inserted a blank column after every such Group of columns. If a red mark cell should appear in the corresponding row for multiple entries it could save a lot of time in identifying them. There are about 800 such columns. Please go through the attached sheet​

 

Attachments

  • Test 1.xlsx
    50.9 KB · Views: 17

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
You can use conditional formatting that uses a countif formula to count how many 1's have been entered . if the count is more than one it flags that row red, just like in your posted worksheet.

=COUNTIF($B2:$F2,"1")>1 ,,,, this is for checking religion

=COUNTIF($H2:$I2,"1")>1 ,,,, this is for Gender
 

Attachments

  • flag_duplicates.xlsx
    49.7 KB · Views: 16
Top