Largest values in an array

An array formula I came across that lists the largest N values of an array.

In the example below, D1:D5 contains the five largest values from A1:A13

largevals.jpg

Leave a Reply