Forum Discussion
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-0000000000162707 | A | 1 | |
| OR-0000000000157638 | A | 1 | |
| OR-0000000000158608 | B | 2 | |
| OR-0000000000157599 | B | 2 | |
| OR-0000000000174000 | B | 2 | |
| OR-0000000000164019 | B | 2 | |
| OR-0000000000164784 | B | 2 | |
| OR-0000000000153344 | C | 3 | |
| OR-0000000000155686 | C | 3 | |
| OR-0000000000155142 | C | 3 | |
| OR-0000000000157965 | C | 3 | |
| OR-0000000000161288 | C | 3 | |
| OR-0000000000164005 | C | 3 | |
| OR-0000000000164828 | C | 3 | |
| OR-0000000000173899 | C | 3 | |
| OR-0000000000158613 | D | 4 | |
| OR-0000000000164078 | D | 4 |
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, "") )If I understand your question correctly, you want to sort on the combination of columns B and C.
I'm afraid that is not possible - you'll have to sort on a single column with a formula based on the contents of columns B and C.
- Thanks
