Download Excel File: https://excelisfun.net/files/EMT1712.xlsx
Learn how create a re-usable function to append tables with an Excel Formula. This tgrick comes from Excel Online Teammate cr gr0912.
Topics:
1. (00:00) Introduction.
2. (00:30) New excelisfun introduction from Geert, the Exceleer.
3. (00:51) Online Excel Team. Cr gr0912 at YouTube sends these amazing advanced array formula tricks.
4. (01:17) Power Query is usually better for appending tables.
5. (01:30) Look at the eight formulas used to create the append.
6. (02:11) How to use the INDEX function and the row_num argument to convert different sized tables into same size tables to we can append with IFS function. The trick is to get the number one in the right position by using ghost pre-rows.
7. (09:08) LET Function.
8. (10:20) LAMBDA Function.
9. (11:45) Paste LAMBDA function into Defined Name Manager dialog box.
10. (12:47) Test new Function to append.
11. (13:04) Summary, Closing and Video Links.