How to detect a linear combination of 2 names within a range of cells including that row?

Hi there,

I have an issue with a formula that I can't figure out, hopefully someone here can help me. Please check my spreadsheet sample attached to this post, you will have all the information to understand what I'm trying to do.

Here is a summary though but I'm not sure it will make any sense if you don't look at the spreadsheet:

I'm trying to find duplicates(s) of a linear combination of 2 cells in 1 single row (row of the formula) within a range of cells that also includes that row. The formula needs to write DUPLICATE if the linear combination of Name 1 + Name 2 or Name 2 + Name 1 of 1 single row exists more than once in a cell range also including the row of the formula.

I found a way to do it but only when the names to be detected are not within the cell range of the row of the formula, but this is not what I'm trying to do.

Like I said, this probably don't make any sense, but you will understand if looking at my spreadsheet.

Thanks everyone!

In C2 copied down, try

Formula:

Please Login or Register  to view this content.

when you delete the cell you end up getting the duplicate returned because there its matching column A with column B and one of them is a blank.
This small modification to ChemistB's formula seem to address that by adding a space between the two columns results in the formula to avoid the mismatching

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Try this modification of ChemistB's formula:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

Another one

=LOOKUP(MIN(INDEX(COUNTIFS(A$2:B$9,A2:B2),)),{0;1;2},{"";"OK";"Duplicate"})