Returns the k-th largest value in a data set.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
LARGE(array, k)The LARGE function identifies the value at a specific rank within a range or array of numbers. It is useful for finding top-performing data points, such as the highest or second-highest scores in a list.
=LARGE({10, 20, 30, 40}, 2)Результат: 30
Returns the 2nd largest number from the provided array.
The function will return a #NUM! error.