List results filtering...

[GUIDO22]

Hi There

I am analysing reams of horse-racing results data. I attach a sample copy of a sheet. Currently, I list all results and prices attained.
However, I wish to filter the results I get by way of the number of runners in each race. So, I only wish to display results for say 10 runners or less. I need the fields to reflect this. Now, I do know how to do this using conditional code on a row/cell by cell basis.

There will always be 3 selections in every race, one selection on each row - - this data is copied and pasted from another source. What I want to avoid is having to enter the specfic number of runners on each row.
So, in summary I wish to filter all three results that represent one race based on the value of a single cell ONLY. I am sure this is possible just need a little direction if anyone could help please..

However, do bear in mind that I am compiling daily results list so I want to be able to replicate this sheet every day with minimal fuss ie. I wish to have a solution that will enable me to 'block' copy cell formula each time I replicate the sheet..... and not require me to work through each race group changing cell values

thank you in advance.

 

[noboffinme]

Hi Guido22,

I'm trying to understand what you mean in order to answer you. You want the data to appear as it shows in the range A6-B24, & not like the range A30-B34. You don't want the three '9s' appearing, just one '9' in Cell B32?

You've added that you already can do this using conditional code on a row by row basis, can you explain/demonstrate a bit of what you mean? Thanks