| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| BIFF format definition | Excel Discussion (Misc queries) | |||
| Need help with some data manipulation - to Biff | Excel Worksheet Functions | |||
| Hello Biff are u here | Excel Discussion (Misc queries) | |||
| "Search" Function with answer prepared by Biff for Brantty on 01/0 | Excel Discussion (Misc queries) | |||
| To Biff: Using Match with multiple criteria | Excel Worksheet Functions | |||
Linear Mode
