Hi,

Is there a way to calculate the k largest number of only those numbers in column A which have a certain criteria in column B.

For example,

A B
1 a
2 a
3 a
4 b

I want the function to look at the whole list in column A and return the k largest number of those that have "a" in column B, so the answer here should be 3.

What about if there were more conditions in columns C, D, etc.?

Thanks