Скачать или смотреть SORT & FILTER but keep headers & CHOOSECOLS

Excel's FILTER & SORT dynamic array functions are useful but quite limited if you must copy & paste the headers in for it to work well, plus you often don't need all the columns, only a few. This is where the new functions come in:
CHOOSECOLS lets you choose which columns to keep and in which order
TAKE allows you to keep only the top row (as does CHOOSEROWS)
VSTACK allows you to stack the header row with the rest of the data

To download example files, enter email here: https://www.xlconsulting-asia.com/soc...


Note that the order in which you state the functions is important, I go through what is the order you must use to make this work well.

00:00 - Introduction
01:46 - FILTER
02:14 - SORT
02:56 - VSTACK to get headers
03:17 - TAKE
04:05 - CHOOSECOLS
04:53 - Use Column names
06:30 - DROP just in case
07:39 - Choosing the wrong order