"Biff" wrote...
....
Enter this formula in F2 and copy to G2:
=IF(AND(SUMPRODUCT(--(ISNUMBER(MATCH($I2:$K2,
$C2:$E2,0))))=2,SUMPRODUCT(--(ISNUMBER(MATCH($C2:$E2,
$I2:$K2,0))))=2,COUNTIF($I2:$K2,C2)0),C2,"")
Enter this formula in H2:
=IF(AND(SUMPRODUCT(--(ISNUMBER(MATCH($I2:$K2,
$C2:$E2,0))))=2,SUMPRODUCT(--(ISNUMBER(MATCH(C2:E2,
I2:K2,0))))=2,COUNTIF($I2:$K2,E2)0,
COUNT(F2,G2)<COUNT(I2:K2)),E2,"")
....
Unfortunately, these formulas would give
5 | 9 | 5 || 5 | 9 | 5 || 5 | 9 | 9
when the results (between the ||s) should presumably be
5 | 9 | _
since there's only one 5 in the I:K cols.
|