How to use large function?

[Eric]

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

 

[Dave Peterson]

Why not stay in that same thread?

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

 

[Bob Phillips]

See response in excel.misc

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Teethless mama]

Assuming a header in Row1
A2 to A13 contain your data

To get unique values go to
Data > Filter > Advanced Filter > select Copy to another location > List
range: select your range including a header > Copy to: select any blank cell.
I use (B1) in this case > click Unique records only > OK

Formula in C2: =LARGE($B$2:$B$7,ROWS($1:1))
Drag to copy from C2 to C4 ( the result will be 58,55,and 52)

 

[Teethless mama]

another way...

B2: =LARGE(IF(FREQUENCY($A$2:$A$13,$A$2:$A$13)>0,$A$2:$A$13),ROW($1:1))

Drag to copy from B2 to B4

 

[Teethless mama]

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