Min-Max question
 

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

Min-Max question
 

Just point to the cell in the array formula:
=MIN(IF(Data!A1:A6=B2,Data!B1:B6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Gina" wrote:
=MIN(IF(Data!A1:A6="Apples",Data!B1:B6))

If instead of typing "Apples" I wanted to reference Cell B2 of the current
worksheet to find the value- Do you know how I could do that?

Min-Max question
 

Thank you Max. That works :)

"Max" wrote:

Just point to the cell in the array formula:
=MIN(IF(Data!A1:A6=B2,Data!B1:B6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Gina" wrote:
=MIN(IF(Data!A1:A6="Apples",Data!B1:B6))

If instead of typing "Apples" I wanted to reference Cell B2 of the current
worksheet to find the value- Do you know how I could do that?

Min-Max question
 

Welcome, Gina
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
---
"Gina" wrote in message
...
Thank you Max. That works :)