How to Use the SORTN Function in Google Sheets

[@skalawag0523]

hello, how to sort highest to lowest value two column data but exclude cell with zero or blank value? thank you

[@arckk3728]

Is there a way to provide it with a certain parameter? For instance in your example what if you wanted to find which products sold less than 700 and then return those? Or adversely, above 700?

[@ModernSchoolBus]

For that kind of task, I think you are better off using the FILTER function. You can FILTER to only return values from a cell range that are less than 700, or greater than 700. Here is my video on the FILTER function: ruclips.net/video/CrYAeSFsy0U/видео.html

[@arckk3728]

@@ModernSchoolBus very quick reply. Thank you very much, I will check that out 🙂👍

[@arckk3728]

@@ModernSchoolBus really good work on this video by the way. The syntax explanation is a very handy section

[@demonicflame632]

if the [sort_column1] is optional how does it sort the range if nothing is provided? which column does it sort it by then?
also, please tell me what the default value of [is_ascending1] is

[@ModernSchoolBus]

Great questions. If a sort_column1 is not provided it will then sort from your first column or "the column with the lowest index" number. It also sorts ascending by default

[@demonicflame632]

@@ModernSchoolBus thank you so much