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.

--
Biff
Microsoft Excel MVP


"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