delete rows two different criteria

Hello,
I am developing my project and would like some assistance please.
On race days there are certain races I would like to automatically delete from the program.
Firstly on the heading for each race there is an item relating to the track conditions.
e.g Good 3.
Now I would like to be able to check the days meeting and delete any races and the horses where
the race is classified as Soft 6,Soft 7, Heavy 8,Heavy 9, Heavy 10.
The second group relates to the number of horses in the race.
Here I wish to eliminate all races that have less than 8 runners or greater than 18 runners.
I have enclosed a small sample worksheet.

Hello Joe,
Thanks for your response.Unfortunately that's what I am up against.
I did try obtaining the track conditions in the same column but but have been unable to achieve that.
Sample enclosed.

Try the attached

Please Login or Register  to view this content.

Hello,
Thank you all for your contributions. These are greatly appreciated.
@Joe31623 like you ,I am impressed with the knowledge and skill these members show in assisting others.
Now I have attempted to try both solutions with a varied set of race meetings including incorrect spellings etc.
The solution provided by Leith Ross has worked perfectly on all occasions. Thank you.
Unfortunately when I try to use different race meetings and run the program provided by jindon it clears the sheet of all data. I am not sure what I might be doing wrong as I am not experienced in working with these codes.
Also as Joe pointed out I would like to know what is the reason for including Gpood in the code.

Gilnic,

Many of jindon's solutions that he posts on this forum include Regexp expressions. It is an extremely powerful yet difficult to understand (upon first glance) VB (not VBA) and other coding languages' search method. Based on the syntax, I can tell that Gpood is an error; however, I believe the code works because jindon thought you were to exclude that condition.

Jindon's solution is designed to clear the sheet of all previous data; however, it can be easily modified to not do that. Since Leith provided you a solution for that, I don't think that is necessary. Let me know if you need further development on this project and I'll be happy to help if I can. I'm not as good as these guys, but I'm learning.

For further info. on regular expressions, YouTube has a few resources -- including this one: https://www.youtube.com/watch?v=DRR9fOXkfRE

Hello @jinjon,
If in another scenario I only want to delete the Heavy 8,9,10 and not the Soft 6-7 is it as simple as deleting the Soft [6-7]|from the formula previously provided.

Originally Posted by gilnic

Unfortunately when I try to use different race meetings and run the program provided by jindon it clears the sheet of all data. I am not sure what I might be doing wrong as I am not experienced in working with these codes.

So, no idea.

Hello @Leith Ross,
I wonder if you might have the time please to look at the sheet and see why it is not eliminating all the
<8 starters races.
These still show in the result sheet.2.43pm,2.47,3.28,5.36 and 7.30pm