Hi Bernard,

I'm afraid it keeps returning #VALUE. I had tried this before posting this
question, and have just tried again. Sorry, still no luck...

Thanks anyway,
Just Anna

"Bernard Liengme" wrote:

It a matter of 'rolling your own'; you need to modify MAX to do what you
want
This worked for me: =MAX(IF(A1:A15="a",B1:B15,""))
In A col I had letters like 'a', 'b', 'c'
In B col I have numbers
The formula found the largest value in B col when the corresponding A col
entry was 'a'
NOTE: this is an array function and must be entered with CTRL+SHIFT+ENTER,
not with just ENTER
Excel will enclose your formula within { } in the Formula Bar
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Just Anna" wrote in message
...
I need to calculate the max and the min of a certain column (say B) as long
as the name in Col A matches a certain value. Basically it would have to
do
the equivalent to @sumif. I can't find any function that does that... Is
there any? In alternative, can I use subtotals but in such a way that the
results are in a different sheet, not in the same sheet as the data?
Thanks in advance for your help!
Regards,
Just Anna