Find Smallest value in column

I need to find the smallest value in column B where the value in column
A is a specific thing.

Example...

A B
orange 1
orange 2
red 1
orange 4
orange 7
red 3
red 9
orange 6
orange 34
red 8


So, i need to find the lowest number in column B where the colour is
RED (in this case the answer would be B3). Any Clues?

Hi!

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER:

=MIN(IF(A1:A10="Red",B1:B10))

Or, use a cell to hold the criteria:

C1 = Red

=MIN(IF(A1:A10=C1,B1:B10))

Biff

"azidrane" <joshczinger@gmail.com> wrote in message
news:1149654189.936373.105090@i40g2000cwc.googlegroups.com...
>I need to find the smallest value in column B where the value in column
> A is a specific thing.
>
> Example...
>
> A B
> orange 1
> orange 2
> red 1
> orange 4
> orange 7
> red 3
> red 9
> orange 6
> orange 34
> red 8
>
>
> So, i need to find the lowest number in column B where the colour is
> RED (in this case the answer would be B3). Any Clues?
>

Beauty, Thanks mate!

You're welcome!

Biff

"azidrane" <joshczinger@gmail.com> wrote in message
news:1149657129.031677.248330@u72g2000cwu.googlegroups.com...
> Beauty, Thanks mate!
>