Biff I need your help!!
 

(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(M IN(C6:H6),C6:H6,0)))&LEFT(INDEX($C$1:$H$1,MATCH(MI N(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 a
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 need your help!!
 

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(M IN(C6:H6),C6:H6,1))))

That isn't my solution! <bg

My solution works! <vbg

See your original post.

Biff

"Lorne Oliver" wrote in message
ups.com...
(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(M IN(C6:H6),C6:H6,0)))&LEFT(INDEX($C$1:$H$1,MATCH(MI N(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 a
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 need your help!!
 

Oh yeah... right (blush)

Thanks

Biff wrote:
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(M IN(C6:H6),C6:H6,1))))

That isn't my solution! <bg

My solution works! <vbg

See your original post.

Biff

"Lorne Oliver" wrote in message
ups.com...
(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(M IN(C6:H6),C6:H6,0)))&LEFT(INDEX($C$1:$H$1,MATCH(MI N(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 a
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