Find Smallest value in column

  • Thread starter Thread starter azidrane
  • Start date Start date
A

azidrane

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
 
Back
Top