Uploaded February 2014 | Updated September 2026, 53 minutes ago

---

Debra Dalgleish from contextures.com shows how to get the last value when the data is sorted http:--blog.contextures.com-archives-2014-02-04-find-last-item-in-group-with-index-match-
A very nice solution using index, match, and countif functions.
But what if the data isn't sorted and you want an option to get the last, 2nd last or 3rd last group item?
In this video I use an array formula to retrieve the required row of data.
Download the Excel file here: https://d.docs.live.net/0e2cae36cc000317