Advanced Sorting in Excel: Multi level, horizontal, with formula
HTML-код
- Опубликовано: 12 июл 2024
- Sorting is important, I show how to avoid messing up your data when you sort and also how to sort normally, with many levels, vertically or horizontally, custom lists and also how to use the SORT function and the SORTBY functions.
You can download the example files here: www.xlconsulting-asia.com/you...
00:00 Introduction
00:26 Single column sorting
00:41 Avoiding issues
02:08 Sort by colour
02:41 Reapply
03:05 Multi level sorting
03:54 Sort by custom list
04:55 Sort horizntally
05:49 Sort with formula Авто/Мото
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
Hey that’s a good approach but yes spill isn’t allowed on tables