dynamic array for matching value in another column

Hi,

Can someone help me to find a way to get a dynamic range/array based on a criteria in another column?

Let's say in column A, the range A1:A10 has "Coffee", A11:A20 has "Tea" and in column B, I have their different rates. I need to right a formula to calculate the MIN and MAX value. The challenge I am facing is the the ranges are not fixed as the "Coffee" or "Tea" can have more than 10 instances in column A.

Is there any way to decide the dynamic range for "Coffee" or "Tea" in column A or their rates in column B?

Thanks.

Maybe these (to be entered using Ctrl+Shift+Enter, not just enter):

=MAX(IF(A1:A100="Coffee",B1:B100))
=MIN(IF(A1:A100="Coffee",B1:B100))

Try:

=AGGREGATE(14,6,B1:B100/(A1:A100="Coffee"),1)

Or:

=MAX(OFFSET($B$1,MATCH("Coffee",A:A,0)-1,,COUNTIF(A:A,"Coffee"),1))

Normal Enter.