Download Excel Start File: people.highline.edu/mgirvin/Y...
Download from: people.highline.edu/mgirvin/Ex...
1. Create Dynamic Range using INDEX & MATCH Functions to find last 5 values in a column
2. Use Dynamic range inside SUM and AVERAGE functions
3. Use INDEX, MATCH and ROWS with Collapsible Ranges to extract the last 5 values in a column
Негізгі бет Excel Magic Trick 856: Last 5 Values In Column: Formulas For Adding, Averaging and Extracting Data
Пікірлер: 45