I have another formula question similar to my previous post.

Now I would like to create a formula in one cell that would produce the
lowest amount given in a range. For example:

Column A Column B
Apples $5
Oranges $20
Bananas $15
Apples $10
Pears $50
Apples $30

From the chart above, I can see that the LEAST amount spent on Apples was
$5. I would like to create a formula that would lookup Apples in column A and
then give me the lease amount I've spent on apples in the corresponding
amount from column B.

Any help is much appreciated. Thank you!

Use =MIN(IF(A1:A6="Apples",B1:B6))
but enter it with CTRL+SHIFT+ENTER not just ENTER as it is an array formula.
Excel will place the formula with in curly braces {}
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WendyBTR8860" wrote in message
...
I have another formula question similar to my previous post.

Now I would like to create a formula in one cell that would produce the
lowest amount given in a range. For example:

Column A Column B
Apples $5
Oranges $20
Bananas $15
Apples $10
Pears $50
Apples $30

From the chart above, I can see that the LEAST amount spent on Apples was
$5. I would like to create a formula that would lookup Apples in column A
and
then give me the lease amount I've spent on apples in the corresponding
amount from column B.

Any help is much appreciated. Thank you!

If your list is long.....you might like what Data Filter Autofilter
select apples.....will do for you......shows the whole list of Apple
purchases, of you can further select smaller groups.......

Vaya con Dios,
Chuck, CABGx3



"WendyBTR8860" wrote:

I have another formula question similar to my previous post.

Now I would like to create a formula in one cell that would produce the
lowest amount given in a range. For example:

Column A Column B
Apples $5
Oranges $20
Bananas $15
Apples $10
Pears $50
Apples $30

From the chart above, I can see that the LEAST amount spent on Apples was
$5. I would like to create a formula that would lookup Apples in column A and
then give me the lease amount I've spent on apples in the corresponding
amount from column B.

Any help is much appreciated. Thank you!