Hi Harlan!

Tried your formula on the OP's sample data and it worked except for the
entry:

4 | 5 | 5................... _ | 4 | 5

When I tried it on larger random sets of numbers it didn't fare too well.
One thing that happened is when there were no matches in either range the
formula returned #DIV/0!

Biff

"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:1115155194.143783.107820@o13g2000cwo.googlegroups.com...
> Luke wrote...
>>Pardon the new thread about the same thing I posted earlier. I would
>>like to clean up the mistakes I made in my earlier quest. In it's raw
>>form my setup looks like this:
> ...
>
> Supplementing your original example with the additional examples in
> rows 7 to 15 you provided in a follow-up, it looks like C2:E15
> contains
>
> 2 | 8 | 8
> 1 | 0 | 5
> 8 | 3 | 4
> 8 | 6 | 7
> 9 | 0 | 2
> 0 | 4 | 1
> 6 | 2 | 6
> 4 | 5 | 5
> 3 | 6 | 9
> 5 | 0 | 1
> 0 | 0 | 5
> 9 | 2 | 4
> 2 | 6 | 9
> 1 | 4 | 9
>
> and I2:K15 contains
>
> 8 | _ | 8
> 9 | 5 | 1
> 5 | 2 | 4
> 6 | 2 | 8
> 2 | 9 | _
> _ | _ | 4
> 2 | _ | 2
> _ | 4 | 5
> 6 | _ | 6
> 1 | _ | _
> 5 | _ | _
> 2 | 2 | _
> _ | 9 | 9
> 1 | 1 | _
>
> where underscores represent blank cells. If so, and given your
> specifications are refiend in your follow-up messages, try the
> following formula in cell F2.
>
> F2:
> =IF(ABS(COUNTIF($I2:$K2,C2)/
> SUMPRODUCT(COUNTIF($I2:$K2,$C2:$E2))-0.5)<0.5,C2,"")
>
> Fill F2 right into G2:H2, then select F2:H2 and fill down into
> F3:H15. This results in the following in F2:H15.
>
> _ | 8 | 8
> 1 | _ | 5
> _ | _ | _
> 8 | 6 | _
> 9 | 0 | 2
> _ | _ | _
> _ | _ | _
> 4 | 5 | 5
> _ | _ | _
> _ | _ | _
> _ | _ | _
> _ | _ | _
> _ | _ | _
> _ | _ | _
>
> again with underscores representing blanks.
>