Monday, 9 March 2015

How to Find the Nth Largest or Nth Smallest Number in a Range in Excel

Excel LARGE and SMALL Functions to Find the Nth Largest or Nth Smallest Number in a Range
Suppose We have a Range of Numbers , from that data we can find the Nth Largest and Nth Smallest Numbers as below :

Nth Largest Number :
=LARGE(RANGE , N)

Example :
Suppose if you want to find the 5th Largest number from a Range of values , you can use the following formula :

=LARGE(A2:A20 , 5)


Nth Smallest Number :
=SMALL(RANGE , N)

Example :
Suppose if you want to find the 5th Smallest number from a Range of values , you can use the following formula :

=SMALL(A2:A20 , 5)

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts