Large function - Please explain
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.
On Dec 18, 2:45 pm, Danny wrote:
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
|