PDA

View Full Version : [SOLVED:] Need to highlight the entire rows once duplicate values found in two separate columns



mpeterson
09-28-2018, 10:28 PM
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.

Fluff
09-29-2018, 08:38 AM
Using CF select row2 down & use this formula
=OR(AND($D2=$D1,$J2=$J1),AND($D2=$D3,$J2=$J3))

mpeterson
09-29-2018, 09:39 AM
Fantastic .. really fantastic .. you saved me a lot of time, so I do thank you very much .. all the best..

M.

Fluff
09-29-2018, 10:06 AM
Glad to help & thanks for the feedback