Call in the Cavalry - 2015

Im not even going to try and break that 1 down, CB...

Formula:

=IFERROR(IFERROR(IF(INDEX(OFFSET( 'TWPL Fixtures'!$C$3,(C$2-1)*10,1,10,1),MATCH($B3,OFFSET ('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)) > INDEX(OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,2,10,1), MATCH($B3, OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)), "W", IF(INDEX(OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,1,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)) < INDEX(OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,2,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)),"L","D")), IF(INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-1,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)) > INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-2,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)), "W", IF(INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-1,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)) < INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-2,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)), "L","D"))), "M")

Originally Posted by FDibbins

Im not even going to try and break that 1 down, CB...

Where did that one come from?

Anybody have time for a time formula?
http://www.excelforum.com/excel-gene...ml#post4206938