There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Returning the last value based on a condition seems like a difficult problem to solve unless you try one of these easy-to-implement solutions.