Max IF




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.




Jacob Skaria

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like


If this post helps click Yes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
array formulas using MIN MAX 3
Help with time function 4
Imposs? Speed up 1
Max with Multiple Ifs 3
Functions on filtered data 1
Formula Help 1
Array Formula 2