Return the last N active records
Enter one formula in G5. Use the eight source slots A2:D9 in their existing oldest-to-newest order. A slot is active when its ID in column A is nonempty. Return the last F2 active records as ID, Units and Team, with no headings, preserving their original relative order. Retain duplicate IDs, numeric zero and signed units. If F2 exceeds the active count, return every active record. If none are active, return No records in one cell. F2 must be a numeric integer from 1 through 8.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G5. Use the eight source slots A2:D9 in their existing oldest-to-newest order. A slot is active when its ID in column A is nonempty. Return the last F2 active records as ID, Units and Team, with no headings, preserving their original relative order. Retain duplicate IDs, numeric zero and signed units. If F2 exceeds the active count, return every active record. If none are active, return No records in one cell. F2 must be a numeric integer from 1 through 8.
No account. No upload. Just try it.