Flagging duplicates if 2 criteria match

Voyage1

Hi!

I'm trying to build a formula that will identify duplicates from 2 different columns on the same sheet. So the combination of both need to be repeated. The columns are [RCPT] and [1st Test].

Ryan Sides

@Voyage1

Hey there. I'd create a helper column named "Key" to combine the two values together. Add this formula in and convert it to a column formula. =RCPT@row + [1st Test]

Then create the duplicate check column named "Dup Check". Add this formula in and convert it to a column formula. =COUNTIF(Key:Key, Key@row)

Then set a conditional Format on this field so if it is greater than 1, highlight it yellow.

Is that what you were looking for?

Ryan

Ryan Sides

@Voyage1

Hey there. I'd create a helper column named "Key" to combine the two values together. Add this formula in and convert it to a column formula. =RCPT@row + [1st Test]

Then create the duplicate check column named "Dup Check". Add this formula in and convert it to a column formula. =COUNTIF(Key:Key, Key@row)

Then set a conditional Format on this field so if it is greater than 1, highlight it yellow.

Is that what you were looking for?

Ryan

Voyage1

That did work! Thank you so much!

Ryan Sides

@Voyage1 You bet! Glad to hear it.

Ryan