Hi!
I want to create a filter to allow only numbers which appear between minimum 2 and minimum 5 in the last 12 draws.
Another filter to allow only numbers which appeared between minimum 5 and maximum 9 in the last 25 draws.
Another filter to allow only numbers which appeared between minimum 9 and maximum 12 in the last 50 draws.
...
and so on.
How to create any filter to allow only numbers which appeared between minimum A and maximum B in the last C draws ? and set A, B and C whatever you want them to be ? and to be able to create as many filters like this you want 1-2-5-20-30 filters, any number of filters ?
Also, it is hard to find out manually what it should be the minimum and the maximum (A and B) for any filter you want. I tried this in Excel and it is hard. Is there any option to find it automatically for all of them ? Like to optimize all filters together find minimum and maximum for each one but not for any of them separately (which is easy but useless!) but for ALL taken together ?
Thank you very much!