Lowest value and a criteria

[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

 

[Peo Sjoblom]

One way

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

entered with ctrl + shift & enter

where "x" is the criteria

 

[Jason Morin]

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