Lowest value and a criteria

  • Thread starter Thread starter Peter B
  • Start date Start date
P

Peter B

I have a table that have a lot og columns and a lot of
rows. I would like to find the lowest value in column
that is equal to a criteria in another column.

It sounds like a simple thing, but I can't figure out
which funtion to use.

Rgds,

Peter B
 
One way

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

entered with ctrl + shift & enter

where "x" is the criteria
 
Say you want the lowest value in A where B = "e":

=MIN(IF(B1:B30="e",A1:A30))

This is an array-formula, so you must press
ctrl/shift/enter after inserting it.

HTH
Jason
Atlanta, GA
 
Back
Top