Maximum / Largest / Minimum / Smallest

Excel: Максимальный / Наибольший (Минимальный / Наименьший)

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

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.

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

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.

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.

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.

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.

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

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

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

Scroll Conditional formatting the three largest values in the list.

Find address of cell containing maximum value in the list.

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

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

Find the maximum/ minimum among duplicate values.

Find the maximum/ minimum only among the distinct values.

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

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.

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