View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
 
Posts: 187
Default 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