heading row
Column A = Draw number (seial, start at 1)
Column B = Date of Draw
Column C = combo drawn (YOU enter this)
Column D = 1st drawn digit (automated)
Column E = 2nd drawn digit (automated)
Column F = 3rd drawn digit (automated)
Column G = Day (formatted as "ddd" so it shows mon, etc)
Column H = >>>intentionally blank for readability<<<
Column I = A
Column J = B
Column K = C
Column L = D
Column M = E
Column N = F
Column O = O1 the first "missing" number
Column P = O2 the second "missing" number
Column Q = O3 the third "missing" number
Column R = P1 first combo O1, O2, first winning digit
Column S = P2 first combo O1, O2, second winning digit
Column T = P3 first combo O1, O2, third winning digit
Column U = P4 first combo O2, O3, first winning digit
Column V = P5 first combo O2, O3, second winning digit
Column W = P6 first combo O2, O3, third winning digit
Column X = P7 first combo O1, O3, first winning digit
Column Y = P8 first combo O1, O3, second winning digit
Column Z = P9 first combo O1, O3, third winning digit
Column AA = R1 (results column straight or boxed... uses a big nested IF statement, copy and paste)
Column AB = R2
Column AC = R3
Column AD = R4
Column AE = R5
Column AF = R6
Column AG = R7
Column AH = R8
Column AI = R9
row 2 and beyond... if it has an "=" copy exactly because it's an excel formula...)
NOTE: autofill works across as well as down, after row 2 is built, simply autofill DOWN 100 rows and plug date and combo info in...
Column A start with 1, increase by 1
Column B Date of Draw, format mm/dd/yyyy
Column C combo drawn (YOU enter this)
Column D =INT(C2/100)
Column E =INT((C2-(D2*100))/10)
Column F =INT((C2-((D2*100)+E2*10)))
Column G =B2 (formatted as "ddd" so it shows mon, etc)
Column H >>>intentionally blank for readability<<<
Column I =IF(F2<9,F2+1,0)
Column J =IF(I2<9,I2+1,0)
Column K autofill from J2
Column L autofill from J2
Column M autofill from J2
Column N autofill from J2
Column O autofill from J2
Column P autofill from J2
Column Q autofill from J2
Column R =($O2*100)+($P2*10)+D2
Column S autofill from R2
Column T autofill from R2
Column U =($P2*100)+($Q2*10)+D2
Column V autofill from U2
Column W autofill from U2
Column X =($O2*100)+($Q2*10)+D2
Column Y autofill from X2
Column Z autofill from X2
Column AA =IF(R2=(($D3*100)+($E3*10)+$F3),"S",IF(R2=(($D3*100)+($F3*10)+$E3),"B",IF(R2=(($F3*100)+($E3*10)+$D3),"B",IF(R2=(($F3*100)+($D3*10)+$E3),"B",IF(R2=(($E3*100)+($D3*10)+$F3),"B",IF(R2=(($E3*100)+($F3*10)+$D3),"B"," "))))))
Column AB autofill from AA2
Column AC autofill from AA2
Column AD autofill from AA2
Column AE autofill from AA2
Column AF autofill from AA2
Column AG autofill from AA2
Column AH autofill from AA2
Column AI autofill from AA2