delete rows two different criteria

[gilnic]

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.

[joe31623]

It's possible, but the format in that excel spreadsheet is a nightmare to work with. Can you upload a document that has been formatted so that all track conditions are in the same column? That and other common-sense formatting would be helpful.

A split function could be used to separate the string that includes track conditions by spaces, but sometimes the track condition is at the end of the string and sometimes it's not. Perhaps it would be easier to work with if you provided a list of track conditions you could check against.

[gilnic]

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.

[Leith Ross]

Hello gilnic,

The attached workbook has a button on the "result" worksheet to run the macro shown below. The data is cleared each time the macro is run.

Please Login or Register  to view this content.

[jindon]

Try the attached

Please Login or Register  to view this content.

[joe31623]

Gilnic -- These two guys impressed me and I learned a lot on this thread! Sometimes I love to be wrong.

I edited this post to say: If you go with jindon's code, I think you can eliminate the "Gpood 3" from my previous post (I believe to be INCORRECT: "correct Gpood 3" to "Good 3").

Unless I'm wrong, what that line of code does is sets some conditions to eliminate the Area (that includes a range of cells) and it just so happens "Gpood" never occurs. Perhaps it is there on purpose for debugging purposes.

[gilnic]

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.

[joe31623]

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

[gilnic]

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.

[jindon]

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.

[gilnic]

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