All formulas go in the top left of their respective sections and can be copied across and down:
Vtracs:
Code:
=IF(R88="","",--RIGHT(R88+5,1))
Odd:
Code:
=IF(ISODD(R88),R88,"")
Even:
Code:
=IF(R88="","",IF(ISEVEN(R88),R88,""))
Repeaters:
Code:
=IF(R88="","",IF(OR(COUNTIF($R87:$U87,R88)>0,COUNTIF($R89:$U89,R88)>0),R88,""))
Leap Frog (couldn't figure out your formatting):
Code:
=IF(R88="","",IF(OR(ISNUMBER(MATCH(--RIGHT(9+R88,1),$R87:$U87,0)),ISNUMBER(MATCH(--RIGHT(11+R88,1),$R87:$U87,0)),ISNUMBER(MATCH(--RIGHT(9+R88,1),$R89:$U89,0)),ISNUMBER(MATCH(--RIGHT(11+R88,1),$R89:$U89,0))),R88,""))
Sequentials:
Code:
=IF(R88="","",IF(OR(ISNUMBER(MATCH(--RIGHT(9+R88,1),$R88:$U88,0)),ISNUMBER(MATCH(--RIGHT(11+R88,1),$R88:$U88,0))),R88,""))
Doubles:
Code:
=IF(COUNTIF($R88:$U88,R88)=2,R88,"")
Triples:
Code:
=IF(COUNTIF($R88:$U88,R88)=3,R88,"")
Quadruples:
Code:
=IF(COUNTIF($R88:$U88,R88)=4,R88,"")