Max Function - Creating Range

  • Thread starter Thread starter calebmichaud
  • Start date Start date
C

calebmichaud

Hi there

I have 2 columns. Column A has text (either a P, C, NE) and Column B
has numbers.
I am trying to find the max number in Column B that has a P entry.

Is there a way to do this.
 
=max(if(a1:a10="p",b1:b10))

=average(if(isnumber(a1:a9),a1:a9))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

or maybe...
=if(countif(a1:a10,"p")=0,"no p's",max(if(a1:a10="p",b1:b10)))
 
The =max(if(a1:a10="p",b1:b10)) array formula works perfect. however
in addition to P i also have T and R.

Can i make an overall IF statement with this array...something like
=IF(A1="P", Max(if(a1:a10="p",b1:b10)), IF(A1="T", Max(if
(a1:a10="p",b1:b10)),.........
 
just answered my own question....works great.



The =max(if(a1:a10="p",b1:b10)) array formula works perfect.  however
in addition to P i also have T and R.

Can i make an overall IF statement with this array...something like
=IF(A1="P", Max(if(a1:a10="p",b1:b10)), IF(A1="T", Max(if
(a1:a10="p",b1:b10)),.........






- Show quoted text -
Click to expand...
 
Back
Top