Large function - Please explain

[Danny]

Hi,

1.
LARGE({3,4,5,2,3,4,5,6,4,7},3) equals 5

2.
LARGE({3,4,5,2,3,4,5,6,4,7},7) equals 4

Please explain why number 2's answer is 4.

Thank you

 

[Ron Coderre]

Using your numbers in descending order (for more clarity):

=LARGE({7,6,5,5,4,4,4,3,3,2},1) =7
=LARGE({7,6,5,5,4,4,4,3,3,2},2) =6
=LARGE({7,6,5,5,4,4,4,3,3,2},3) =5
=LARGE({7,6,5,5,4,4,4,3,3,2},4) =5
=LARGE({7,6,5,5,4,4,4,3,3,2},5) =4
=LARGE({7,6,5,5,4,4,4,3,3,2},6) =4
=LARGE({7,6,5,5,4,4,4,3,3,2},7) =4
=LARGE({7,6,5,5,4,4,4,3,3,2},8) =3
=LARGE({7,6,5,5,4,4,4,3,3,2},9) =3
=LARGE({7,6,5,5,4,4,4,3,3,2},10)=2

Were you looking for something different?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[T. Valko]

Enter your numbers sorted in descending order in a range of cells, say,
A2:J2 -

7,6,5,5,4,4,4,3,3,2

Now enter these numbers in A1:J1 -

1,2,3,4,5,6,7,8,9,10

Notice what number is under the 7 in cell G1. 7 being the 7th largest.

 

[Dave F]

The second formula is looking for the seventh largest number. You
have a sequence of 10 numbers, three of which repeat themselves: 3
appears twice, 4 appears three times and 5 appears twice. Thus, in
order from smallest to largest you have: 2,3,3,4,4,4,5,5,6,7.

Counting from largest to smallest (i.e., from left to right), we see
that the seventh digit is 4.

 

[Niek Otten]

Excel Help doesn't specify what it does with ties.

But The 7th largest has 6 "above" it: 7,6,5,5,4,4


--
Kind regards,

Niek Otten
Microsoft MVP - Excel



| Hi,
|
| 1.
| LARGE({3,4,5,2,3,4,5,6,4,7},3) equals 5
|
| 2.
| LARGE({3,4,5,2,3,4,5,6,4,7},7) equals 4
|
| Please explain why number 2's answer is 4.
|
| Thank you

 

[Danny]

Very well explained. Thanks a lot. HAPPY HOLIDAYS!