How to determine the minimum value with given condition?

E

Eric

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
 
J

JMB

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.
 
S

squenson via OfficeKB.com

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top