« Advanced Functions: INDIRECT | Main | Conditional Formatting I »

March 09, 2005

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

Posted by Dave at March 9, 2005 06:03 AM

Comments

Post a comment




Remember Me?