Advanced Excel Functions | BYROW vs MAP vs SCAN vs REDUCE | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-...
File Reference for this video: 0220 BYROW MAP SCAN REDUCE Comparison.zip

★ About this video ★
In this video we compare 4 of Excel's LAMBDA help functions to find out what they do and when to use them.

INCLUDES:
0:00 Introduction
0:29 Data
1:11 BYROW
5:34 MAP
7:10 SCAN
9:50 REDUCE
12:10 Wrap up

Previous video:    • Change category while keeping history...  

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel