Using your posted workbook...
This regular formula returns the appropriate score in AD:AO range
AD6: =IF(COUNT($K6:$P6)>1,IF(ISNUMBER(MATCH(K6+COLUMN(K6)/10000,INDEX(LARGE($K6:$P6+COLUMN($K6:$P6)/10000,{1,2}),0),0)),MATCH(K6,{0;20;32;43;50;56;0;0},1),0),0)
Copy that formula into AF6, AH6, etc...Be sure to change the K6 references to L6, M6, etc as appropriate
Example:
AF6: =IF(COUNT($K6:$P6)>1,IF(ISNUMBER(MATCH(L6+COLUMN(L6)/10000,INDEX(LARGE($K6:$P6+COLUMN($K6:$P6)/10000,{1,2}),0),0)),MATCH(L6,{0;20;32;43;50;56;0;0},1),0),0)
Is that something you can work with?
Bookmarks