Maximum Formula

[lstewart]

Hi,
I'm looking for a formula that will give me the maximum1 maximum2, maximum3, maximum4 figures from a range
e.g
cell A1 = 46
cell A2 = 40
cell A3 = 40
cell A4 = 30
cell A5 = 25
cell A6 = 27

The result would be
46
40
40
30

The max formula does not seem suitable because I have multiple numbers the same and it will only list them once.

Thank you.

 

[sheetspread]

Use the large function instead

 

[lstewart]

Got it.
Thank you, much appreciated.