Statistical
★ 90 · ◉ 34 · All versions
=MAX()
Returns the largest value in a set of values.
=MAX(number1, [number2], ...)
Daily Tasks
Reporting
Ranking & Top N
21 functions for this use case · out of 12 defined
Statistical
★ 90 · ◉ 29 · All versions
=MIN()
Returns the smallest number in a set of values.
=MIN(number1, [number2], ...)
Daily Tasks
Reporting
Statistical
★ 60 · ◉ 24 · All versions
=LARGE()
Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.
=LARGE(array, k)
Daily Tasks
Ranking & Top N
Math & Trig
★ 85 · ◉ 23 · Excel 2010
=AGGREGATE()
The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
=AGGREGATE(function_num, options, ref1, [ref2], …)
Reporting
Ranking & Top N
Statistical
★ 30 · ◉ 19 · Excel 2019
=MAXIFS()
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria: numbers, dates, text, etc. This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.
=MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Conditional Aggregation
Ranking & Top N
Statistical
★ 40 · ◉ 19 · Excel 2010
=PERCENTILE.INC()
PERCENTILE.INC returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. You can use this function to establish a threshold of acceptance.
=PERCENTILE.INC(array,k)
Ranking & Top N
Descriptive Statistics
Statistical
★ 80 · ◉ 19 · All versions
=SMALL()
Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set.
=SMALL(array, k)
Ranking & Top N
Compatibility
★ 25 · ◉ 17 · All versions
=PERCENTILE()
Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. If k is non-numeric, PERCENTILE returns the #VALUE! error value. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
=PERCENTILE(array,k)
Ranking & Top N
Descriptive Statistics
Compatibility
★ 25 · ◉ 17 · All versions
=QUARTILE()
Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE to find the top 25 percent of incomes in a population. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, you should consider using the new functions from now on, it may not be available in future versions of Excel.
=QUARTILE(array,quart)
Ranking & Top N
Descriptive Statistics
Statistical
★ 35 · ◉ 17 · Excel 2010
=QUARTILE.INC()
QUARTLE.INC returns the quartile of a data set, based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups.
=QUARTILE.INC(array,quart)
Ranking & Top N
Descriptive Statistics
Lookup & Reference
★ 50 · ◉ 16 · Excel 2021
=SORT()
Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.
=SORT(array,[sort_index],[sort_order],[by_col])
Daily Tasks
Sort, Filter & Dedupe
Statistical
★ 15 · ◉ 15 · Excel 2010
=PERCENTILE.EXC()
The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
=PERCENTILE.EXC(array,k)
Ranking & Top N
Descriptive Statistics
Lookup & Reference
★ 60 · ◉ 14 · Excel 2021
=SORTBY()
Learn about the SORTBY function, which sorts the contents of a range or array based on the values in a corresponding range or array. SORTBY is in a class of functions called dynamic arrays.
=SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2],…)
Sort, Filter & Dedupe
Ranking & Top N
Statistical
★ 25 · ◉ 12 · Excel 2010
=RANK.AVG()
Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.
=RANK.AVG(number,ref,[order])
Ranking & Top N
Lookup & Reference
★ 45 · ◉ 12 · Excel 365
=TAKE()
TAKE function
=TAKE(array, rows,[columns])
Sort, Filter & Dedupe
Ranking & Top N
Statistical
★ 10 · ◉ 11 · Excel 2010
=PERCENTRANK.EXC()
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
=PERCENTRANK.EXC(array,x,[significance])
Ranking & Top N
Statistical
★ 25 · ◉ 11 · Excel 2010
=PERCENTRANK.INC()
Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.
=PERCENTRANK.INC(array,x,[significance])
Ranking & Top N
Statistical
★ 12 · ◉ 11 · Excel 2010
=QUARTILE.EXC()
QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive.
=QUARTILE.EXC(array, quart)
Ranking & Top N
Descriptive Statistics
Statistical
★ 55 · ◉ 11 · Excel 2010
=RANK.EQ()
Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. If you were to sort the list, the rank of the number would be its position.
=RANK.EQ(number,ref,[order])
Daily Tasks
Ranking & Top N
Compatibility
★ 60 · ◉ 8 · All versions
=RANK()
Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.) For more information about the new functions, see RANK.AVG function and RANK.EQ function.
=RANK(number,ref,[order])
Ranking & Top N
Statistical
★ 30 · ◉ 6 · Excel 2019
=MINIFS()
The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
=MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Conditional Aggregation
Ranking & Top N