detect doubles, threes, quadruples * of the code 01 02 03 04 05

jack

Member
detect doubles, threes, quadruples
* of the code 01 02 03 04 05
* goal to see delays
http://www.mediafire.com/file/pr5eoux1704aq1f/codigto_01_02_03_04_05.xlsx/file
 

Frank

Member
detect doubles, threes, quadruples
* of the code 01 02 03 04 05
* goal to see delays
http://www.mediafire.com/file/pr5eoux1704aq1f/codigto_01_02_03_04_05.xlsx/file

I dont know what you are doing in cols Q toV , your examples dont make sense. What are you trying to find in these columns ?? You have x's where there are NO MATCHES.

I assume I got the other pairs triples etc correct.

http://www.mediafire.com/file/2lshuxji6xxap55/codigto_01_02_03_04_05.xlsx/file
 

jack

Member
hello FRANK! thanks for the hard work,
the focus is on the doubles, cracks and quadruples hit from the 01 to 05 limit
* ie the start or start of the bet
* goal is to get it started, lotofacil (brails) is accumulated at 40 million dollars
* when I win will be rewarded, I need to find a way to filter the double trios, etc.
* To start the bet, do you have any idea of filters? please
my lottery is from 01 to 25 and is drawn 15 numbers
 

jack

Member
answering the question = is to detect the presence of numbers
* starting time limit 01 to 05,
* so per column you can see the delay per column,
* the problem is how to filter
 

jack

Member
hello frank this is the matrix of my lottery =
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
frank if i type where there is 0102 03 04 05
* if i digitatum of the other4 lines does the macro do?
* example = if you type
11 12 13 14 15, does the macro do the double triplets and quadruples too? or on another line that I type?
 

Frank

Member
hello frank this is the matrix of my lottery =
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
frank if i type where there is 0102 03 04 05
* if i digitatum of the other4 lines does the macro do?
* example = if you type
11 12 13 14 15, does the macro do the double triplets and quadruples too? or on another line that I type?

Did you think I was some kind of mind reader ? At what point in your ORIGINAL POST did you mention that you would need to change 1,2,3,4,5 to 11,12,13,14,15 or another sequence?? you only mention SPECIFICALLY 1,2,3,4,5 !

Do you think its OK to waste someones time and then just move the goalposts to something else ?

Do you think I've got nothing better to do perhaps ??

You do need to THINK CAREFULLY before posting any request, listing EVERYTHING you need the spreadsheet to do. These things take time to create, you can't just wave a magic wand and make it do something that you had not thought of in the first place.

One day perhaps, you will spend as much time carefully crafting your request as the person helping you would spend in trying to help you, I suspect that will not happen in my lifetime sadly.

On this occasion I have amended the sheet to allow you to type in and change your sequence in the GREEN cells. It wont happen again.

Have you not noticed that the delays as you call them are averaged at the top of each column ? e.g every 9.6 draws. Why do you need a filter ? The delays vary from nothing to dozens. Only the average is statistically of use. What use is a long list of draw numbers when the sequence happened ?
You could always use Autofilter to seach for x's in each column and get the draw numbers, but why ?

The same link for the updated version.
 

jack

Member
hello, hhuuh, what a working beauty, FRank, the planilia is like a house
* sometimes you need to change something, life is hard
to go gambling, I have to have a reference
* initial, the planilia was very good, you can use
* for your lottery at 49/6 but the doubles, cracks and quadruples has to be the empty ones because your lottery
* it's 49 in 6, mine is 25 in 15,
you can use the method to find the quintuple
* empty from 1 to 10 from 49/6, is just a suggestion.
thank you frank for the hard work one day the reward will come
 

Sidebar

Top