MAX function

Excel » Functions » Statistical » MAX function »

How to use the MAX function

The MAX function calculates the largest number in a cell range. The formula in cell D3 extracts the highest number […]

Find and return the highest number and corresponding date based on a condition

This article describes how to filter records based on the maximum value of a specific item. There are names in […]

How to quickly find the maximum or minimum value [Formula]

This article demonstrates formulas that will return the largest and smallest numbers, the corresponding column headers, the cell addresses, and […]