Lotto triplets,quads and more

hello pls vba code for this file example extract triples: 1,4,6 OR 2,9,48

and i must 4-6digitcode to extract examle 1,4,6,12 1,4,6,12,15 1,4,6,12,15,18 PLS

https://www.dropbox.com/s/0ksum9oewkxuw7o/200test.xlsx

this macro is for triples

Please Login or Register  to view this content.

Hi dragon66,

Invest ;-) some time to read http://www.excelforum.com/forum-rule...rum-rules.html

During reading focus on code tags and on attachments. Also do not SHOUT http://netiquette.wikia.com/wiki/Rul...t_use_all_caps

So please, edit your post. I insist.

As for the macro - not tested and edited it only - try this:

Please Login or Register  to view this content.

hi kaper and 5,6 digit combination single script? pls this sub blah4 script is perfectly nice

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Follow the rules: http://www.excelforum.com/forum-rule...rum-rules.html

Edit your post. Now 2 posts.

I nic więcej nie napiszę, dopóki nie poprawisz!

for 5s:
as I already wrote, just add i loop and again use median:

Please Login or Register  to view this content.

For 6 - note that you don't have to use loops at all - you are just checking if all are repeated. and moreover - they are already sorted so code is shorter again.
Please note how indenting improves readability of the code

Please Login or Register  to view this content.

and sub7 for this file? https://www.dropbox.com/s/idepug3hfwzgg37/7new.xlsx This is really the last:p perfect!!! thx you very much