This can be done by using a few different formulas, and this article explains all possible ways. In some situations, however, you may need to drill down into your data further to find the max value based on certain criteria. In our previous tutorial, we looked at the common uses of the MAX function which is designed to return the largest number in a dataset.
The article shows a few different ways to get the max value in Excel based on one or several conditions that you specify.
