Max IF


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
 
Ad

Advertisements

J

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
"{=<formula>}"

=MAX(IF(A1:A5="A",B1:B5))
=AVERAGE(IF(A1:A5="A",B1:B5))
=MIN(IF(A1:A5="A",B1:B5))


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

Top