Results 1 to 2 of 2

Thread: Highlight duplicates data form sheet to another sheet

  1. #1
    Seeker bixha's Avatar
    Join Date
    Oct 2015
    Ferizaj, Kosovo
    Excel Version
    excel 2010

    Highlight duplicates data form sheet to another sheet

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

    Basically I have a spreadsheet which shows months Sep ,Oct, Nov and Dec we have to tracking ID number so if ID number is sheet Sep or Oct I want to highlight it as duplicates data so that case I am informed that ID number has been last month. What I am trying to do is highlight duplicate ID Numbers across the worksheets as we shouldn't have the same ID Number in the two different sources.
    See attachment.
    Attached Files Attached Files

  2. #2
    I have a similar task. I have a workbook for each month, a sheet for each date. As I enter data for a new day, I need to know whether the same value has already been entered on a previous day. I know how to compare two columns and highlight for duplicates, but is there a way to compare for "repeat offenders" for a whole month? I've attached an example with data on sheets 1, 2, 3, and 19. The actual spreadsheets I'm using have much more information but the data I want to compare is on Column B on each sheet.
    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