Hi everyone,I need help for 1 formula, I'm not able yet to transfer link so here I explain.
This excel file is to keep track of every number's skip ( for the 1000 numbers daily3 ).
And when a number come out ,it start counting from 1 again and up until it hit again and with an ( Index ) formula maybe in column G, I'll be able to see where each number break they cycle, simple chart but I like to see how the numbers move around and see where are they breaking point.
But my problem is that the formula that convert the 3 digit to the whole number does not do a good job because, the number is not reconise by my other formula ??? here is my display.
A3 and going down : Draw number.
B3 and going down draw date.
C3 first digit of CA daily3 going down.
D3 second digit.
E3 third digit.
F3 is the (3) digits combine together to create the whole number with formula : =C3&D3&E3 maybe not the right one for that ?
G empty column for separation.
And then in :
H1 000
E1 001
J1 002
ETC.... up to 999.
Then I have to put the number 1 starting cell : H3 all the way to : ALS3 .
Then in cell :
H4 I have this formula : =IF(ISNA(MATCH(H$1,$F4,0)),H3+1,1)
drag it all the way to ALS4 and then all the way down to the last draw.
Here is my problem this formula starting in H4 do not reconise the number in F3 and won't do the job !!? when I drag it down for all the numbers it does not start at 1 when the number has been hit ??
Can someone help to correct it please, Thank you.