Delete rows based on condition

Hello everyone..

Just wanted to ask for your help.. I have here a report where in I would like to delete the rows in which the specific cell did not meet the condition.

Example:
In Row 1, if Cell B to C is equal to any of the values listed in Cell M then row 1 will retain.
In Row 2, if cell B-C does not match to any of the values listed in Cell M then row 2 will be removed and so on...

I have attached a sample..


Hope you can help me with this..

Hello Jaslake.. Thank you!

M will always be populated. It serves as the legend.

B and C will be based from my generated report. So I will be putting a series of data in columns B and C. Then if it matches the data in M then that row will retain else it will be rmoved.

Am I making sense or do i Confused you?