How to conditionally return the last value in a column in Excel

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.