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.