Hello. This article is about looking up values in Excel. Balaji asks: How can I create a Query that displays maximum value in one column and the date corresponding to the maximum value in the adjacent column ?   There are several ways to do this. In this video, I will have a look at the MATCH and INDEX formulas to solve […]

Read more