SORT & FILTER but keep headers & CHOOSECOLS скачать в хорошем качестве

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