Results 1 to 2 of 2

Thread: Check and identify duplicate entries

  1. #1

    Check and identify duplicate entries

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

    Attached Files Attached Files

  2. #2
    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts