Return 2 highest numbers in a range

[PP]

I have a three number range, eg 15, 22, 29 ... I want to return the 2 highest numbers in that range in 2 cells after it (in the example it would return 22, 29)

Any help much appreciated.

 

[GlennUK]

Use the LARGE function, like:
=LARGE(range,1)
and
=LARGE(range,2)

 

[snoopyhr]

here is slight variation from above, a bit more dynamic.

Excel Workbook
	B	C	D
2	Data		top 2
3	15		100
4	20		45
5	45
6	29
7	100
8
Sheet12