When I sort a column in Google Spreadsheets, the blanks always seem to sink to the bottom. Can I have rows with blank cels be organized first / highest?
Alternatively, is there a function wherein I can specify a sort order based on an array of options, like
[
[1,''],
[2,'i'],
[3,'x']
]
where 1,2,3 is the sort order DESC. the string is the char to match and associate with that sort order.
Best Answer
I do not think you have any way to control the sort order directly, other than ascending or descending, so suggest a lookup table and a helper column (to determine the sort order) with a formula in that such as:
where ColumnB is the one to be sorted, ColumnE the sort order and ColumnF a number starting at
1and incrementing by one for each row.