Large function - Please explain

  • Thread starter Thread starter Danny
  • Start date Start date
D

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
 
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)
 
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.
 
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.
 
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
 
Back
Top