Advanced Sorting in Excel: Multi level, horizontal, with formula

[@Kings_New_Clothese]

useful stuff. However, I need to sort a large table of text into six groups. So I have 120 in the list and I want to sort each group into 1,2,3,4,5,6 order. Is that possible?

[@learnspreadsheets]

Hi sort by custom list should do that which I cover later in my video

[@AndreasScheller-pv1eu]

Interesting! Am i the only one that morphs date into Tables ? (Windows strg-t) For me far superior because A: makes the Filter default and allows empty data rows. B: i can give it a name to easily select table via the fast Menu. C: Vba Listobject attributes are now there. D: easy formating style (each secobd row diffrent colours + templates). E: autopasting formulas for each new row. F: and the best thing, the [] and @ operator, all Lookups become so easy. Why (@ means same row and [] allows dynamic referenckng of Collumns so instead of (Matrix, b4) i can use (tablename, collumnheader name) and when i change the collumnheader name or add news the formulas will work as intended. Downside: overflow/spill cant be abused in the table :( and calculating can take its tame so manuell calc kinda mandatory

[@learnspreadsheets]

Hey that’s a good approach but yes spill isn’t allowed on tables