Min-Max question

G

Gina

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
 
G

Gary''s Student

=MIN(IF(Data!A1:A6="Apples",Data!B1:B6))

MUST be an array formula entered with CNTRL-SHFT-ENTER rather than just the
ENTER key.
 
G

Gina

Thank you, this worked great. I was missing the control-shift-enter, and
your reminder made it work well.

Gina
 
G

Gina

=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?

Gina
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning row headings for values greater than 0 10
sum if column is equal to 2 options 3
Macro with line graph 2
Import data and keep duplicate rows of data 0
Another Running Totals Problem 9
Sumif w/ relative column reference 3
Is there a way to parse multiple values in a cell and applycalculations on those values ? 0
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1

Top