Forum Discussion
Sort Function (SortBy) - Trying to get empty cells to return empty cells using the sort function
This is just and aesthetic issue. I have a table with around 7 headings for a simple account information table. Not all accounts have a value for each heading/field so on entering data those cells a...
A similar solution,
= LET(
sorted, SORT(array),
IF(sorted<>"", sorted, ""))
This is clear to read and does not require the SORT to be performed twice.
Even better. I was not familiar with the Let function and I like the ability to assign a variable or a computation to a name.