Forum Discussion
Sorting rows with an "x" in them
I'm trying to sort my spreadsheet by multiple columns. How do I indicate to Excel that if a row has an "x" in the "A" column, then that row gets sorted to the bottom of the document? I want to b...
Using 365, I do not touch the source data. Instead, I use a formula to produce the reordered data on a separate worksheet.
= LET(
current, Table1[x]<>"x",
sorted, SORTBY(Table1,current,-1),
sorted
)Then again, as I am not deleting information from the source data, I could simply filter the displayed data
= FILTER(Table1, Table1[x]<>"x")With legacy Excel similar things can be achieved manually with the Advanced Filter or with PowerQuery.