Forum Discussion

camema's avatar
camema
Copper Contributor
Jul 30, 2023

Sorting different column

How can I sort a table based on different columns. In the example, not using the column D formula, but a custom list. Grazie  e2Id Spec_Tech_Severity > L1 Ground_Severity > L1   OR-00000000...
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jul 30, 2023

camema 

If you want an interactive process without a helper column you have problems.  An ideal solution might be to sort the data using Power Query before it is ever loaded to the spreadsheet.  Another possibility is to leave the data table untouched and use a formula to generate a sorted copy.

= LET(
    specTech, CHOOSECOLS(table,2),
    ground,   CHOOSECOLS(table,3),
    combined, specTech & ground,
    sorted,   SORTBY(table, combined),
    IF(sorted<>"", sorted, "")
  )

Resources