Request = split cracks from draws without repeating digits =
Ex = draw of 80/5 = 25 45 60 76 79 = 25 60 79, 45 60 79 ...
It has draws where it does not have the crack, only double
Ex = 02 25 54 63 66 = 02 54, 25 63, 02 63 ... there are no cracks but there are double without repetition of digitios, please
https://www.excelforum.com/attachmen...1&d=1509702256
I think you shall do manually at least first few rows, stating what you did, and why.
For instance in row 2. shall it be any 3 elements combination without repeating digits? like
13 30 58 63 64
-- >
13 58 64 30 58 64
?
How about 3rd row
05 15 32 33 48
is 33 not allowed at any time (as it has repetition of 3?)
Best Regards,
Kaper
Hello kaper, ok the 33 is not allowed and also the rest of the twins
* 11 to 77, is not allowed because of repetition
* Objective is to extract from the line of draws of 5 numbers = the possible cracks
There will be sweepstakes in which no cracks are left blank
* Macro will only extract cracks without repeating digits of each draw line
* There is an option that when I place new sweepstakes the macro automatically
Ex = 13 30 58 63 64 = cracks without repetition of digitios = 13 58 64, 30 58 64 ....
13 58 64 30 58 64
?
They are draw lines of 5 numbers only from them to extract the cracks.
To be more specific - what is the meaning of crack (despite crevice, cocaine, etc.)
Samples, samples, samples ...
Hello, kaper, I'm from Brazil, I'm using google translator,
Google translates poorly! crack, it means breaking the training
You have to be careful with the translation
Objective = to separate in the lines of draw of 5 numbers the broken ones
* To be able to use in the previous work to see the backward formations
You should only extract the trios
google = translate trincas(00 00 00) as crack
samples, samples, samples...
PS. I'm from Poland - does it matter?
No, poland, beautiful country when winning a jackpot or euromilhoes I will visit poland
Kaper = is simple = extract the trios without separation of digits What is the doubt ???
Hello kaper, if it is very difficult to make the macro by has many variants.
* Let's do it another way, okay?
Ex = 25 45 60 76 79
Five numbers combined by 3 of 10 trainings
25 45 76
25 45 79
25 45 60
25 76 79
25 76 60
25 79 60
45 76 79
45 76 60
45 79 60
76 79 60
Each draw line will have 10 trios
It is not hard to make, it's rather problem with clear description what shall be achieved and with a time to prepare macro.
as per original description:
it's quick and you can add many thousand rows - will still be quick. Just data have to start as you shown in A4 and there shall be no header and nothing in cells around.
Please Login or Register to view this content.
As you can see parts of the code from previous thread were re-used
Last edited by Kaper; 11-04-2017 at 04:25 AM.
Hello,KAPER, perfect ,. Very good job, magnificent, the best,
When I win a jacpot, you will be rewarded, I will visit Poland
Conglatutations, congratulations, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks