How to find max value in range with criteria in Excel

How to find max value in range with criteria in Excel

Max, as used in the above statement, is the short form for the word maximum. Maximum is a mathematical function used when we are referring to the value with the largest limit in any data range. When data is defined by either minimum or maximum function, you know absolutely comparison is being done or differentiation