Mar 08 2024 01:05 PM
You can specify many ranges to sort by. For example:
=SORTBY(A17:G250, I17:I250, 1, K17:K250, -1, M17:M250, 1, N17:N250, -1)
This will sort the range A17:G250, first ascending by I17:I250, then within that descending by K17:K250, next ascending by M17:M250 and finally descending by N17:N250.
Mar 09 2024 10:25 AM
Mar 09 2024 12:15 PM
Try deleting the formula from the range first, then enter it anew.
Mar 11 2024 12:36 AM