View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lorne Oliver Lorne Oliver is offline
external usenet poster
 
Posts: 9
Default 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