I'm slightly modifying a another function I found online for a table of values. It's purpose is to detect duplicate pairing of the same name from a roster of about 20 persons. The desired result would be 20 unique pairs.
Original Function =IF(A1=F1, "DUPLICATE!", "GOOD!") This checks if a person is paired up with themselves. For example, if Wolverine=Wolverine, then "DUPLICATE!" is indicated in a separate column.
The value for cell A1 is a fixed number, and the value for cell F1 is a randomly generated number using the RANK function that references a RANDBETWEEN function in a separate column.
The fixed number from A1 is associated with a person's name in B1, and the random number from F1 is associated with another person's name in C1 which has a VLOOKUP function.
This works perfectly.
However, I'm trying to modify the function by also checking if a pair of two different people shows up again together in a different table. For example, if Wolverine and Jean were paired up in one table, I don't want them to be paired up in a separate table.
I tried this, =IF(A1=F1, "DUPLICATE!",IF(B1:C1=B29:C29,"DUPLICATE!","GOOD!"))
For some reason the parentheses for the second if function are red, and when it runs the entire function I keep getting a "#VALUE" within a cell of the "Duplicate Detector" column.
I can't find the website I got the instructions from. I'll try to find it for further clarification.
Bookmarks