find records based on their rating

[mq1973]

Hi,

I have a list of records with different ratings. I need to generate a list of records with a rating of 7 or less.
Rating image.jpg

Thanks in advance

[wk9128]

Just use EXCEL's default automatic filtering function

Array Formula , Drag down and accross

[mq1973]

Just use EXCEL's default automatic filtering function

Array Formula , Drag down and accross

Thanks so much wk9129. The data is in a sheet called Sheet1
How do I modify the formula to reference another tab called Sheet1?

Thank you again for your help

[mq1973]

never mind. I was able to figure it out