How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.

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.