View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default How to use large function?

Should be:
ROWS($1:1) instead of ROW($1:1)


"Eric" wrote:

Referring to the post in General Question

I get a list of numbers as show below
58,58,58,39,39,52,37,43,55,58,55,52.
I would like to the largest one, which is 58, and the second largest one,
which is 55, and the third largest one, which is 52. But when I use the
function large, which don't work the way I describe, and the first, second,
third largest numbers is still 58 in this lists.
Does anyone have any suggestion on how find the first largest number is 58,
and the second largest number is 55, and the third largest number is 52?
Thank you in advance
Eric