Looping While Checking for Duplicate cells

I think you could do this with Conditional Formatting

Highlight your data from rows 2 to the last used row and enter in this CF formula.

=AND($G2="", COUNTIFS($G$2:$G$1000, "<>", $S$2:$S$1000, $S2, $T$2:$T$1000, $T2))

Make sure the 1000 in the formula goes up to or beyond the last used row of your data

I suggested a solution in post #2. Did you try it? Do you need help with Conditional Formatting?

It looks like you put the conditional formatting formula starting in row 1. That would mess up the formula.

Select your data rows starting with rows 2 to your last used row and then apply the CF formula.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Example is attached!

See attached with the CF formulas added.

Row 15 doesn't seem to have a match.

I have an older version of Excel which doesn't have the COUNTIFS function so I used SUMPRODUCT instead which can do the same thing. You could use either formula. I haven't changed anything from what I suggested to you, and I don't know why it didn't work before.

I have attached a new Example file with an added After_CF tab so you can see how the formula =AND($G2="", COUNTIFS($G$2:$G$2500, "<>", $S$2:$S$2500, $S2, $T$2:$T$2500, $T2)) affects the data. Also, I was unable to open the file you attached.

Try this cf formula.

= AND($G2="",SUMPRODUCT(($G$2:$G$2500<>"")*($S$2:$S$2500=$S2)*($T$2:$T$2500=$T2)))

Originally Posted by khemistry1911

It worked like a charm! What did you change??

The column G criteria in the COUNTIFS function wasn't correct. If column G is numbers or blanks, you could use this...

=AND($G2="", COUNTIFS($G$2:$G$1000, ">0", $S$2:$S$1000, $S2, $T$2:$T$1000, $T2))