Hi,
I'm looking for someone to help me with thoses formulas, thank you ?
My data are for 5/56 and from C1 to G1 going down.
1) I need formulas that will return the repeat numbers from only the previous combination draw but NOT FROM THE POSITION OF THE NUMBER ,I need to have 1 formula per number repeated.
Ex : The first formula would look for the 1st repeated number in the previous draw.
The second formula would look for the 2nd repeated number in the previous draw ...Etc...
Ex : if the draws are :
previous : 5 - 34 - 38 - 51 - 56
New : 4 - 21 - 34 - 53 - 56
The first formula would return the number : 34
The second formula would return the number : 56
The third formula would return the number : 0
The fourth formula would return the number : 0
The fifth formula would return the number : 0
2 ) Same thing pretty much but those formulas would look for the number (+1 ).
Ex : if the draws are :
previous : 2 - 15 - 27 - 53 - 55
New : 16 - 21 - 40 - 54 - 56
The first formula would return the number : 16
The second formula would return the number : 54
The third formula would return the number : 56
The fourth formula would return the number : 0
The fifth formula would return the number : 0
3 ) Same thing but those formulas would look for the number ( +2 ).
4 ) Those formulas would look for the number ( -1 ).
5 ) And to finish those formulas would look for the number ( -2 ).
Thank you in advance for your help Serge.
I'm looking for someone to help me with thoses formulas, thank you ?
My data are for 5/56 and from C1 to G1 going down.
1) I need formulas that will return the repeat numbers from only the previous combination draw but NOT FROM THE POSITION OF THE NUMBER ,I need to have 1 formula per number repeated.
Ex : The first formula would look for the 1st repeated number in the previous draw.
The second formula would look for the 2nd repeated number in the previous draw ...Etc...
Ex : if the draws are :
previous : 5 - 34 - 38 - 51 - 56
New : 4 - 21 - 34 - 53 - 56
The first formula would return the number : 34
The second formula would return the number : 56
The third formula would return the number : 0
The fourth formula would return the number : 0
The fifth formula would return the number : 0
2 ) Same thing pretty much but those formulas would look for the number (+1 ).
Ex : if the draws are :
previous : 2 - 15 - 27 - 53 - 55
New : 16 - 21 - 40 - 54 - 56
The first formula would return the number : 16
The second formula would return the number : 54
The third formula would return the number : 56
The fourth formula would return the number : 0
The fifth formula would return the number : 0
3 ) Same thing but those formulas would look for the number ( +2 ).
4 ) Those formulas would look for the number ( -1 ).
5 ) And to finish those formulas would look for the number ( -2 ).
Thank you in advance for your help Serge.
, but I'm wondering if you ever figured it out or got the answer elsewhere? This sounds like information worth knowing.
