MIN and MAX across columns

B

Bark!

Hi folks

I have gender in one column and age in second column. I need to find minimum
age for male patients, for female patients and maximum age as well. I tried
with IF function but it doesn't work

=IF(O3:O15="M";MIN(P3:p15)) in Q3 cell

O P Q
1 GENDER AGE MIN(M) MIN(F) MAX(M) MAX(F)
2
3 M 45
4 F 63
5 M 83
6 M 63
7 M 84
8 F 49
9 F 55
10 F 62
11 M 73
12 F 42
13 M 54
14 F 64
15 M 73

I think I'm on the right path but I need your help. Thanks in advance
 
B

Bob Phillips

=MIN(IF($A$3:$A$15="M",$B$3:$B$15))

etc.

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Peo Sjoblom

=MIN(IF(O3:O15="M",P3:p15))

entered with ctrl + shift & enter (this is important)
 
B

Bernard Liengme

Your formula works when entered as an array formula - use CTRL+SHIFT+ENTER
to conform the formula.
(I assume your county uses ; for argument separation)
It this does not work make sure you have single letters in O; for example
does =O3="M" return TRUE?
best wishes
 
P

Peo Sjoblom

It doesn't work regardless if it is entered with ctrl + shift & enter



--

Regards,

Peo Sjoblom
 
B

Bark!

Bernard Liengme said:
Your formula works when entered as an array formula - use CTRL+SHIFT+ENTER
to conform the formula.
(I assume your county uses ; for argument separation)
It this does not work make sure you have single letters in O; for example
does =O3="M" return TRUE?
best wishes

OMG thnak you ppl

yes ; is the separator in my country
 

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


Top