Hi,

What is the easiest way to make a max/av/min IF formulas?

Supposing I have the following list

A 1
B 2
B 2
C 3
A 5

I would like a function that will calculate the max av and min for A, B and
C hence returning the following output.

Max Av Min
A 5 3 1
B 3 2.5 2
C 3 3 3

I know how but it seems more awkward that it needs to be.

Thanks
LiAD