Learn excel max, min, large, small, dmax, dmin formula

MAX() function

Used to get the max value.

formula: =MAX(select the range of cells according to your need)

LARGE() function

From the MAX function you will get the first largest value but using the LARGE function you can the get second, third fourth, etc number of largest values present in a column.

formula: =LARGE(F4(column or range of cells),the number of largest value we want)

Find the F4 button on the keyboard. After selecting the column or range of cells press the F4 button then give a comma and then the number of largest values you want. F4 is used to fixed any value or cell or column.

In the example, you will get the third largest value in the mark column.

MIN() function

Used to get the min value.
formula: =MIN(select the range of cells according to your need)

SMALL() function

From the MIN function you will get the first smallest value but using the SMALL function you can the get second, third fourth, etc number of smallest values present in a column.

formula: =LARGE(F4(column or cells),the number of smallest value you want)

Find the F4 button on the keyboard. First selecting the column or range of cells and press the F4 button then give a comma and then the number of largest values you want. F4 is used to fixed any value or cell or column.

In the example, you will get the third smallest value of mark column.

DMAX() function

Here you will also get maximum value but here you can use condition. You will get max value according to the condition.

formula: =DMAX(Table, field, Condition)

In the formula, field means that column name which column value you want to see as a result. Here you have to select only the column name cell not the whole column.

Suppose you have a Brand, Version, Generation, and price column in the table. Now according to the Brand, Version, Generation you have to find price.
At first copy, the column names of the table and paste it anywhere on the sheet. Then below the Brand, Version, Generation write Brand, Version, Generation value, and below price write DMAX formula.

Here the field is the price column and the condition is Brand, Version, Generation column value.

So according to the image you want to find the max price of AR brand which version is i5 and generation is 7th.

DMIN() function

Here you will also get minimum value but here you can use condition. YOu will get min value according to the condition.

formula: =DMIN(Table, field, Condition)

In the formula, field means that column name which column value you want to see as a result. Here you have to select only the column name cell not the whole column.

Suppose you have a Brand, Version, Generation, and price column in the table. Now according to the Brand, Version, Generation you have to find price.
At first copy, the column names of the table columns and paste it anywhere on the sheet. Then below the Brand, Version, Generation write Brand, Version, Generation value, and below price write DMAX formula.

Here the field is the price column and the condition is Brand, Version, Generation column value.

So according to the image you want to find the min price of AR brand which version is i5 and generation is 7th.