L
LiAD
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
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