Consulting

Results 1 to 4 of 4

Thread: Need to highlight the entire rows once duplicate values found in two separate columns

  1. #1

    Need to highlight the entire rows once duplicate values found in two separate columns

    Hi All,
    I have a data worksheet with over 35,000 rows and 20 columns A-T. I need to highlight contiguous rows that contain duplicate values that exist in both ColD, AND ColJ, regardless of how many duplicates they could be.
    For example:
    ColD - - - - - - - ColJ
    Oragne - - - - - Sugar
    Orange - - - - - Sugar
    Orange - - - - - Sugar
    These three contiguous rows should be highlighted in yellow because duplicates found in BOTH columns. They could be any number of contiguous rows 2-n, they are three in this example.

    Orange - - - - - Sugar
    Banana - - - - - Sugar
    Cannot highlight any of these rows despite having duplicates in one column only which is ColJ in this example, regardless of how many duplicates may exist in that column.

    Can I get some precious help with this request please?

    Many thanks in advance.

  2. #2
    Using CF select row2 down & use this formula
    =OR(AND($D2=$D1,$J2=$J1),AND($D2=$D3,$J2=$J3))

  3. #3
    Fantastic .. really fantastic .. you saved me a lot of time, so I do thank you very much .. all the best..

    M.

  4. #4
    Glad to help & thanks for the feedback

Tags for this Thread

Posting Permissions

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