# Maximum / Largest / Minimum / Smallest

### Minimum Positive / Maximum Negative Value in EXCEL

we Find the minimum positive value in the range of positive, negative integers and 0.

### LARGE function with criteria in EXCEL

to Find, for example, the second largest value in the list, you can use the function LARGE(). The article presents the solution of the problem, when the largest value you should find among all of the list values, but only among those that satisfy certain criteria.

### Maximum/ Minimum value based on criteria in Excel

Нахождение максимального/ минимального значения - простая задача, но она несколько усложняется, если МАКС/ МИН нужно найти не среди всех значений диапазона, а только среди тех, которые удовлетворяют определенному условию.

### EXCEL Functions: SMALL

SMALL()the English version SMALL(), returns the k-th the lowest value of data array. For example, the formula =LEAST(A2:B6,1) returns the minimum value (first minimum) of the range A2:B6.

### EXCEL Functions: LARGE

LARGE()English version LARGE (), returns the k-th largest value from the dataset. For example, the formula =LARGEST(A2:B6,1) will return the maximum value (first maximum) of the range A2:B6.

### EXCEL Functions: MIN

Find using the function MIN(), English version, MIN (), the minimum value in the argument list. Assume that the range can contain numbers, numerical values in plain text, error values, empty cells.

### EXCEL Functions: MAX

we Find using the function MAX()the English version of MAX (), the maximum value in the argument list. Assume that the range can contain numbers, numerical values in plain text, error values, empty cells.

### EXCEL Functions: DMIN - smallest number that matches conditions

Function DMIN()the English version DMIN(), finds the column the minimum value to satisfy the specified conditions.

### EXCEL Functions: DMAX - largest number that matches conditions

DMAX(), the English version of DMAX(), finds the column the maximum value that satisfies the given conditions.

### Position of Maximum/ Minimum Value in List based on criteria in Excel

Finding maximum/ minimum values - a simple task, but it is slightly more complicated if the M

### Highlight top 3 (largest) values in EXCEL

Scroll Conditional formatting the three largest values in the list.

### Cell address with MAX or MIN value in Excel

Find address of cell containing maximum value in the list.

### Extract multiple longest text strings in EXCEL column

Find in the source list of text values that have the maximum length of the string, and output them in a separate range.

### Find the longest or shortest text string in EXCEL column

Find in the list of text values a string with a maximum / minimum length.

### Maximum/ Minimum based on Duplicate Values in EXCEL

Find the maximum/ minimum among duplicate values.

### Maximum/ Minimum based on Distinct Unique Values in EXCEL

Find the maximum/ minimum only among the distinct values.

### Maximum/ Minimum Absolute Value in EXCEL

Find the maximum value of the modulo range for positive and negative numbers.

### Sum 3 or nth Largest Numbers in Excel (without Duplicates)

Fold three (four, five, etc.) of the largest values in a range. If the range is also repetitive, to take them into account will not.

### Sum 3 or nth Largest Numbers in Excel

Fold three (four, five, etc.) of the largest values in a range.