How to determine the minimum value with given condition?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have any suggestion on how to determine the minimum value with
given condition?
Under column A, there is a list of date in ascending order, and
under column B, there is a list of numbers.
There is a given date in cell C1, and I would like to determine the minimum
value, which is equal or larger than the given date in cell C1, and return
this value in cell D1.
Does anyone have any suggestions?
Thank for any suggestions
Eric
 
Try:

=MIN(IF(A1:A17>=C1,B1:B17))

array entered w/Cntrl+Shift+Enter. If done properly, XL wil put braces { }
around your formula, otherwise you'll get 0 or an error. Adjust ranges to
suit, but don't use an entire column (ie A:A, A1:A65536) unless you have XL07.
 
I would create a new column (let's say G) with the formula in G2 and copy it
down:
=IF(A2>$C$1,B2,"")

Then I would put in D1:
=MIN(G1:G65536)
 
Back
Top