Sunday, November 10, 2013

yogi_Pull Movies With Specified Rating Sorted By Earnings In Ascending Or Descending Order As Noted

                                          Google Spreadsheet   Post  #1415
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 09, 2013
question by Jeff Self (http://productforums.google.com/forum/?zx=jqfpog71krg#!category-topic/docs/spreadsheets/67K-rB-Im5w)
How to filter a column for a minimum value?
I've sorted a spreadsheet but I would like to filter out the rows that don't meet a minimum rating. I have a column called rating with and the rows have values between 1 and 5 in the column. I am sorting on another column but I want to filter out those rows that have a rating below 3. How do I do this?
---
Here you go:


I'd like to sort by earnings and then only show those movies with a rating of 3 or higher.

Thanks!
---------------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment