Result X, when a group of 1 2 3 4 in red exists.

[I need excel help]

Hello all,

I hope I explain this properly.
In col H, I am wanting to get a macro or function that results X, to find the following criteria.

In col G there are numbers only from 1 to 16, there will be numbers up to 24.
The numbers in col G, <=4 are all in red

I am wanting to find the minimum number of 3 red numbers grouped per each individual race.
A group as I will refer it as can also have a gap, but one gap only between any of the four numbers 1 2 3 4..

I have resulted this sheet in col H, all the races that should if I have explained myself properly all the criteria above.

Im sure that I have missed something or have not taken into accout something completely over my head.
Meaning not asking correct question, but please let me know if im missing something.

The races not marked with X, should have the numbers 1 2 3 4 in red quite spaced apart.

Happy to reply to any questions.
Thanks.

[JohnTopley]

Delete delete

[I need excel help]

John, My ID rows 15 to 19 there are the 4 red numbers separated by what I call a gap, in that gap is the number 6.

Caulfield race 4 my ID rows 29 to 32 there are two numbers then a 6 with the number 4.
So, in both cases there are two red numbers separated by a number >=5, this is seen as a block of three.
When there are 3 or 4 red numbers in a block these are of course very easy to see, it's the ones as mentioned above where I get the eye strain, if you know what I mean.
Thanks.

[JohnTopley]

Please Login or Register  to view this content.

Macro tested on sheet "TEST"

[I need excel help]

Good progress.
In this v2 sheet, I have entered in col S where I see errors or not resulting x. Just filter xxx.

I can see that your macro is finding the blocks of three red numbers and also a block of two, gap or number >=5, then another red number.

Just need it to result col S xxx errors of course. Macro quick button also added.

Thanks.

[JohnTopley]

See attached in sheet TEST

[I need excel help]

I make it there should be 252 x rows when X is filtered in my 1st post.
Your first macro counted 94 times.
Your latest sheet counts 44 x.

What would a macro look like if we only looking for blocks of red numbers>=3, so it would find either a block of three or four numbers only.
Thanks.

[JohnTopley]

Latest sheet has 94 (column H of TEST) so I have no idea how you get 44.

252 x rows when X is filtered in my 1st post.

but these included your "errors".

I suspect all this analysis is of little value anyway in that it does not significantly increase the chances of winning!

[I need excel help]

Ok, thanks John, I do hear what you're saying.
My reasoning is based on what calculations I have worked in a race, and over 630,00 rows in an excel sheet, with nearly 59,000 wins as evidence. Which is probably
nearly 99.9% accurate, as I have spent the last 23 years making sure it was.
So, what can happen with my quite accurate stats is that my calculations can produce basically a clump of red numbers, that are quite grouped together and quite frequent.
So that is what I'm trying to produce.
All of my posts are out there, because they are sort of technical, they are always now based around my same cols. Mostly 90%. I know now to concentrate on the significant areas, this is one.
I don't want to drop this, because you have produced extremely accurate results before.
Thanks.

[JohnTopley]

...so where does this leave the results produced... are they correct?

[I need excel help]

Thanks John, let me come back to you with this and I will come up with a good scenario for you which I will improve again in my questioning and doubting in what I am asking. Thank you.

[JohnTopley]

On standby!