Excel 365 + Google Sheets · TAKE
Always show the latest rows
Takes the first rows (positive) or the last rows (negative) of a table.
The formula
=TAKE(A2:B7, -3)What each part means
A2:B7The table-3The last 3 rows
Example
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Date | Sales | Date | Sales | |
| 2 | Nov 1 | 420 | |||
| 3 | Nov 2 | 380 | |||
| 4 | Nov 3 | 510 | |||
| 5 | Nov 4 | 460 | |||
| 6 | Nov 5 | 590 | |||
| 7 | Nov 6 | 610 |
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Date | Sales | Date | Sales | |
| 2 | Nov 1 | 420 | Nov 4 | 460 | |
| 3 | Nov 2 | 380 | Nov 5 | 590 | |
| 4 | Nov 3 | 510 | Nov 6 | 610 | |
| 5 | Nov 4 | 460 | |||
| 6 | Nov 5 | 590 | |||
| 7 | Nov 6 | 610 |
Step by step
- Click cell D2.
- Type the formula:
=TAKE(A2:B7, -3) - Press Enter.
- The results fill the cells below by themselves (it’s a dynamic array formula). Don’t type anything in them.
Where it works
- Excel 365 and Excel 2021 or newer
- Google Sheets
- Excel for the web (free)