Forum Discussion
How to get rows that contain specific value or range of values
Hi friends, Every time I ask a question in this community I receive a quick and brilliant answer, this time won't be different. I'm trying to get rows from a table with a range that contains spec...
haitham From your question it seems you are just trying to filter schools grade higher or equal 9. Try FILTER() function. See attached file.
=FILTER(A2:D7,D2:D7>=9)
Thank you!
What if I want schools that have the 9th grade, the same formula applied to High grade column doesn't seem to work. I tied to work out a FILTER with AND but it didn't return any results.
Would appreciate a help?