Hi guys,

I'd like to find the max value of a column only when another column is equal to something.

For example:

I want the max of column b only if it is equal to dog: answer 16.

A B
1 dog 10
2 dog 15
3 dog 16
4 dog 14
5 cat 7
6 cat 6
7 cat 5
8 fish 80


Thanks a lot