low and high numbers with stats

Morning JBeaucaire I don’t know if its just me but cant seem to get the patterns working is there any chances we can make the columns in a way that when I type a low number like 5 in the first box its on top the when I type the new number like 20 it replaces the 5 in that box and the 5 automatically moves down so that the first number on top is always the most recent and so on? And from there work out that the patterns L,L,L and L,L,H and L,H,H andL,H,L count as hits anything else is a miss and a 0 is a break the way it keeps all the records are perfect it seems thank you also is it possible to add a button that clears all columns and stats and maybe a button that once u click on it brings you to a record that keeps of all results for example we want a result per 3 numbers so it will be 0miss 1 hit 0 break then on the next result of 3 it will be 1miss 0 hits 0break hope my explaining is not to bad thank you again for your time and patients

HLL and HHL must be a miss aswell i think it piks 0 as a low and a break aswell when it must just be a break?

well the chart is correct:

LLL - Hit
LLH - Hit
LHH - Hit
LHL - Hit

seems once i type 0 it breaks but for example 2,12,30 is hit then 0 break then i type 5,5 it goes miss cause even tho it breaks on 0 it picks the 0 as a low and 3 lows are a miss so before i can put in the 3rd number of the pattern it picks up the 0 when i t shoiuld not

thanks it works great i think iv asked this before not sure if it is possable though can we make it so that if i type a number in colume A row 3 and press enter it automaticlly drops down to the row below clearing up row 3 that way i always type the most recent number in that row and the numbers below it keep moving down while still staying with the pattern?

thank you its great, would i be able in future be able to build more patterns into this app? or would i have to make a new one each time?

thank you so much for your help its much appriecated iv also glady clicked the reputation feedback button as u have been a great help but sadly i need to ask you for your help once again it seems its my fault this app has taken so long to complete as iv missunderstood it and only 1 or 2 adjustments need to be made before i can continue it i hope it is not to much of a train smash i am willing to wait a few days if i need to as i dont wish to incovineince you, basicly as far as the 0 goes i need it to be a MISS and only when its typed entered in the cells as the last number of the pattern it becomes a break for example (5,0,5) or (0,20,30) is a miss but 5,5,0 will be a break, so basicly is the 0 is in the pattern on 3s its a miss and only if its the last number of the pattern its a break.

as for the stats this is the most important im hoping you can help me here if the pattern goes L,L,L its a hit and the stats will show (0 misses 1 hit 0 zaggs) if the next patern its a hit the stas will show (0 misses 2 hit 0 breaks/zaggs) now lets say the 3rd pattern misses the stats will show (1 misses 0 hit 1 zaggs) notice how the stats resets when that happns can we take a snap shot of that history to anothe rpart of the form that will show 2 hits occured before the zagg broke the pattern. and if had to continue typing in numbers for the pattern for example L,L,L the stats yet again reset to
(0 misses 1 hit 0 zaggs) and again if the pattern were to break the stats again reset to (0 misses 0 hit 1 zaggs) and again taking a snap shot of that record to another part of the form keeping a history. and that should finally complete the app i appologise for all these inconvieninces im almost out of your life lol i a learning once this app is complete i should manage from there thankyou for all your help thus far

I know its not but it must i explained wrong in the begining i can alawys try and explain my last request again it it is to confusing for you sorry

lets make it so that if any any pattern of 3s if the 0 pops up its a miss, lets forget bout breaks at the moment lets change them to zags if you have 2 hits in a row the stats should read 2 hits 0 miss 0 zaggs if the next pattern misses the stats ill show 0hits 1 miss 1 zaggs and upon this changing of stats the prevoius/history stats of 2 hits 0 miss 0 zaggs will be copied to another part of the form at to keep a record, basicallt the zagg indacates the amount of times the pattern swops from hits and misses hope this is making some sense now