Max IF

  • Thread starter Thread starter LiAD
  • Start date Start date
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
 
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
Array Formula 2
Formula Help 1

Back
Top