Download Excel File: https://excelisfun.net/files/EMT1650.xlsx
Learn how to get the last 5 numbers in a column and then add, average and display the last 5 items. Learn about a simple solution to this common task using the INDEX and ROWS functions and the Excel Table feature. See Six Examples. See the Excel Functions: INDEX, ROWS, SUM, AVERAGE, IF, FILTER and ROW.
1. (00:01) Introduction.
2. (00:24) Create Dynamic Range using INDEX and ROWS function with an Excel Table.
3. (01:28) SUM to add the dynamic range.
4. (01:44) AVERAGE to average the dynamic range.
5. (01:57) Non-Office 365 solution to display last five values.
6. (02:45) When you should NOT use IFERROR Function.
7. (03:30) Office 365 New Calculation Engine solution to display last five values.
8. (03:54) Formula for extracting last five text items.
9. (04:13) FILTER Function solution (not the best option).
10. (04:32) Summary and End Video Links.