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:
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:
https://docs.google.com/ spreadsheet/ccc?key= 0AjzfNI2PWDH6dDM4WGVTTDQ0ZGdhb mRCb3Rzb0RyM3c&usp=sharing
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