Find the highest 2 numbers from the cells.

[asyamonique]

Hello Good Day,
I need a formula wich will show the highest 2 numbers in related cell ranges as given sample below.
Thank you.

32.000		67.000
65.000		65.000
43.000
45.000
67.000
23.000

<colgroup><col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
</tbody>

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	32.000		67.000
2	65.000		65.000
3	43.000
4	45.000
5	67.000
6	23.000
Sheet3

Cell Formulas
Range	Formula
C1	=LARGE(A1:A6,ROWS($1:1))

 

[Aladin Akyurek]

Let's replace 23.000 with 67.000. What would be the 2 results?

 

[asyamonique]

67.000

67.000

<colgroup><col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> </colgroup><tbody>
</tbody>

Both cells gave the same results

 

[Fluff]

Is that what you want as they are the two largest values, or do you still want it to show 67 & 65?

 

[Aladin Akyurek]

67.000

67.000

<colgroup><col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> </colgroup><tbody>
</tbody>

Both cells gave the same results

What I was hinting at is: the results are then 67.000 and 67.000 or 67.000 and 65.000?

 

[asyamonique]

Highest two numbers from a column.

 

[Fluff]

Bot Aladin & myself have asked you the same question, please answer it.

 

[asyamonique]

Hi,

=LARGE([COLOR=Blue]A1:A6,ROWS([COLOR=Red]$1:1[/COLOR])[/COLOR])

That formula is ok,
Thanks again.

 

[Fluff]

You're welcome & thanks for the feedback