Biff I need your help!!

[Lorne Oliver]

(Please view this in "Fixed Font" for clarity)

Biff,
I have come across a strange problem with your solution. As a reminder,
here is the formula used:
=IF(COUNT(C6:H6)<2,"",LEFT(INDEX($C$1:$H$1,MATCH(MIN(C6:H6),C6:H6,0)))&LEFT(INDEX($C$1:$H$1,MATCH(MIN(C6:H6),C6:H6,1))))

The row of names is C1:H1


It all seems to work properly but for three rather wacky combinations.
The table data looks like this:
Games Rodney Welles Scott Mina Barry Lorne
Wk 1 Dbl -01 0 0
Dbl Cr 0 0
These return "WS" and "BL" as results, which is correct.

The problem situations are:
Dbl Cr 0 0
Dbl Cr 0 0
These return "SS" as a result.
Dbl Cr 0 0
This returns "MM" as a result. All other combinations seem to work
correctly. Why these three are wrong is stumping me completely.

Thanks for your help.
Lorne

 

[Biff]

I have come across a strange problem with your solution. As a reminder,

here is the formula used:
=IF(COUNT(C6:H6)<2,"",LEFT(INDEX($C$1:$H$1,MATCH(MIN(C6:H6),C6:H6,0)))&LEFT(INDEX($C$1:$H$1,MATCH(MIN(C6:H6),C6:H6,1))))

That isn't my solution! <bg>

My solution works! <vbg>

See your original post.

Biff

 

[Lorne Oliver]

Oh yeah... right (blush)

Thanks

That isn't my solution! <bg>

My solution works! <vbg>

See your original post.

Biff