The TAKE and DROP functions in Excel are quickly becoming two of my favourites. They make array shaping so easy - and in this dynamic array era, this is important.
This video has it all!
There is a debut for the TRIMRANGE function and also appearances from HSTACK, GROUPBY and XLOOKUP.
Grab your copy of Advanced Excel Formulas
https://www.amazon.co.uk/Advanced-Excel-Formulas-Unleashing-Brilliance/dp/1484271246
📚 Resources
Practise file from the video - https://computergaga.com/_excel/files/formulas/take-and-drop.xlsx
GROUPBY function tutorial - https://www.computergaga.com/excel-groupby-function-single-formula-reports-made-simple/
📺 Related Videos
https://youtu.be/aFHEVQp6Hec - PERCENTOF function in Excel
https://youtu.be/tCwds64-3iw - Seven-day rolling average function
https://youtu.be/FfXjooeY68U - Get non-adjacent columns from arrays
⌚ Timings
00:00 TAKE and DROP in Excel
01:03 Take the last column
03:53 Sum last 6 columns
04:38 With XLOOKUP
07:05 TAKE with TRIMRANGE
09:56 Top 10 list
11:07 Remove headers from GROUPBY
Find more great free tutorials at; https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
TikTok ► https://www.tiktok.com/@computergaga
#excel #excelformulas #learnexcel