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