(Msg. 2) Posted: Wed Aug 27, 2008 7:10 am
Post subject: RE: Min-Max question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=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.
--
Gary''s Student - gsnu200801
"Gina" wrote:
> 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
(Msg. 3) Posted: Wed Aug 27, 2008 7:13 am
Post subject: RE: Min-Max question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you, this worked great. I was missing the control-shift-enter, and
your reminder made it work well.
Gina
"Gary''s Student" wrote:
> =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.
> --
> Gary''s Student - gsnu200801
>
>
> "Gina" wrote:
>
> > 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
(Msg. 4) Posted: Wed Aug 27, 2008 7:24 am
Post subject: RE: Min-Max question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=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
"Gina" wrote:
> 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
(Msg. 5) Posted: Wed Aug 27, 2008 7:36 am
Post subject: Re: Min-Max question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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?
(Msg. 6) Posted: Wed Aug 27, 2008 8:08 am
Post subject: Re: Min-Max question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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?
(Msg. 7) Posted: Thu Aug 28, 2008 3:03 am
Post subject: Re: Min-Max question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Welcome, Gina
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
---
"Gina" <mail2gina.DeleteThis@gmail.com> wrote in message
news:C60F3E73-1B25-472A-A34F-2092930FCF47@microsoft.com...
> Thank you Max. That works
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office