Worksheet named "Data" has two columns, column A is types of fruit. Column B
is quantity of that fruit.

Apples 1
Apples 5
Apples 15
Oranges 1
Oranges 4
Oranges 12


How do I, from another worksheet in the workbook, make a formula that
says--- Look in Data worksheet, and return the minimum quantity of apples.

I have tried several combinations of the "If" and "Min" functions, but can
not seem to put them together well. Can anyone help?

Gina