There are many situation where we need to find the maximum and minimum in a range. Like many other worksheet functions, finding the maximum and minimum also there is a direct functions available. Let us have a quick look into the maximum and minimum excel worksheet functions.
Finding Maximum in a range using the Excel worksheet function:
As said earlier, we need to use max function to get the maximum in a range.
The syntax of max worksheet function is
=max(number1, number 2, number 3…….Number n)
where number1, number 2, number 3…….Number in which we need to find the maximum value.
Examples on MAX excel function:
=max(23,18, 51, 49) this will return 51
=max(A1:A4)
Finding Minimum in a range using the Excel worksheet function:
The syntax of MIN function in excel is
=min(number1, number 2, number 3…….Number n)
Where number1, number 2, number 3…….Number n Number in which we need to find the maximum value.
Examples on Excel MIN function:
=min(23,18, 51, 49) this will return 18.
=min(A1:A4)
We have seen how to find the simple minimum and maximum using the excel functions. But at times we need to find max in a range with a criteria. There is a conditional max function available.
For finding the conditional max in range we need to use DMAX function.
The syntax for DMAX is
DMAX( database, field, criteria )
Where
database is the range of cells that you want to apply the criteria against.
field is the column to find the largest number in. You can either specify the numerical position of the column in the list or the column label in double quotation marks.
criteria is the range of cells that contains your criteria.
Finding Maximum in a range using the Excel worksheet function:
As said earlier, we need to use max function to get the maximum in a range.
The syntax of max worksheet function is
=max(number1, number 2, number 3…….Number n)
where number1, number 2, number 3…….Number in which we need to find the maximum value.
Examples on MAX excel function:
=max(23,18, 51, 49) this will return 51
=max(A1:A4)
Finding Minimum in a range using the Excel worksheet function:
The syntax of MIN function in excel is
=min(number1, number 2, number 3…….Number n)
Where number1, number 2, number 3…….Number n Number in which we need to find the maximum value.
Examples on Excel MIN function:
=min(23,18, 51, 49) this will return 18.
=min(A1:A4)
We have seen how to find the simple minimum and maximum using the excel functions. But at times we need to find max in a range with a criteria. There is a conditional max function available.
For finding the conditional max in range we need to use DMAX function.
The syntax for DMAX is
DMAX( database, field, criteria )
Where
database is the range of cells that you want to apply the criteria against.
field is the column to find the largest number in. You can either specify the numerical position of the column in the list or the column label in double quotation marks.
criteria is the range of cells that contains your criteria.
