I have searched this site looking for answers to use excel in helping me keep up with numbers skiped, numbers by position, etc and have found info from hypersoniq's "how to count skips with excel"
skips for Pick 3 draws
Lets say your data in Excel has the draw number in column A and N1, N2 and N3 in columns B, C and D starting on row #3 and going down. Row 2 can be used for labels. Note it might be best if the width of columns is small in order to see more (a width of 5 is enough).
A - skips not considering the position
The method listed here does take into consideration the position a number has come out but simply when it did come out last.
In cells F1 to O1, enter the consecutive numbers, 0,1, 2, &, 9. In cell F3, enter the formula =IF(COUNTIF($B3:$D3,F$1)>=1,0,F2+1). Then copy this formula across to column O, and down for all the draws.
This will give you a 0 if the number in the top row has come out in the draw or otherwise a number indicating how many draws the number has not come out.
I follow this info but it will not reference the actual draws that I put in
So does anyone have any info that they can send me or share with me regarding having excel reference the actual draws that I put in?