Please enable JavaScript to view the comments powered by Disqus.


Using LARGE() function to sort the data

The formula takes two argument, one is the data, the second is the kth largest value you want to find. When used for sorting, we use ROW(row_num) to get the values sorted from highest to lowest value.

Used Functions

Category: Statistical

Returns the k-th largest value in a data set


LARGE(array, k)

Category: Lookup and reference

Returns the row number of a reference



Lets chat on this