Filtering or displaying multiple conditions

Hi all,

First time poster so hello everyone....


I have a spreadsheet with multiple data and I would like to filter it for specific data display.

Ive attached the file to make it easier.
Basically I have it working but only if I filter by 150 .My issue is how do i then filter e.g. 150 - 300 and 300 - 450 as options.

Code I'm currently using is below but this only allows for the number in the drop box that is selected.Hopefully this makes sense.

Please Login or Register  to view this content.

Possibly a better way of doing it but I'm not that advanced at excel so any help would be greatly appreciated.
Dean

thanks for your response, ive messed around with it but im not sure that its working correctly. Here is a screenshot.

Change Validation List Source to: 0-150,151-300,301-450

M7=AND(AND(G7>=--LEFT(SUBSTITUTE($G$1,"-",REPT(" ",10)),10),G7<=--RIGHT(SUBSTITUTE($G$1,"-",REPT(" ",10)),10)),AND(H7>=--LEFT(SUBSTITUTE($G$2,"-",REPT(" ",10)),10),H7<=--RIGHT(SUBSTITUTE($G$2,"-",REPT(" ",10)),10)),AND(I7>=--LEFT(SUBSTITUTE($G$3,"-",REPT(" ",10)),10),I7<=--RIGHT(SUBSTITUTE($G$3,"-",REPT(" ",10)),10)))

Thankyou all, that works a lot better. Even though I have no clue what it does I will research.

thanks again