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?
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
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
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
hello, how to sort highest to lowest value two column data but exclude cell with zero or blank value? thank you
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?
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
@@ModernSchoolBus very quick reply. Thank you very much, I will check that out 🙂👍
@@ModernSchoolBus really good work on this video by the way. The syntax explanation is a very handy section
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
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
@@ModernSchoolBus thank you so much