Understanding MAP and BYROW helper functions in Excel
Автор: ExcelMoments
Загружено: 2025-04-07
Просмотров: 1297
Understanding MAP and BYROW in Excel: This video creates the intuition for MAP and BYROW functions in Excel. Understanding when to use and When NOT, when either works or just one. MAP and BYROW are similar, but the function nuances must be understood to use them effectively
Link to Excel workbook
https://docs.google.com/spreadsheets/...
00:00 Introduction
00:13 Motivation for the video
01:06 MAP and BYROW Comparison
02:05 Quick visual representation of MAP
04:56 Example 1a - MAP and BYROW (Single Column)
06:40 Example 1b - MAP/BYROW (2-D range)
09:40 Example 1c - MAP/BYROW - SUM/TEXTSPLIT
11:35 Example 2a - SUM a 2D-range by row
13:05 Example 2b - SPLIT by delimiter and SUM by row
16:15 Conclusion
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: