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...