View Single Post
  #25   Report Post  
Harlan Grove
 
Posts: n/a
Default

"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.