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



"Danny" wrote in message ...
| 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