Help: Find MIN() of range for corresponding values > today

[Matt Kruse]

I've done a lot of complex formulas in my excel days, but for some
reason this is stumping me. Can someone help?

I have data like this:

DATE Name Qty
2/12/04 Bill 2
2/13/04 Bill 4
2/14/04 Joe 8
2/15/04 Bill 3
2/16/04 Mary 5

I want to have a cell containing the MIN() of the quantity column, but
ONLY considering dates later than today (or any given date).

So on 2/12, the value would be 2. The next day, the value would then
be 3.

How can I do this in a formula?

Thanks!

Matt Kruse
http://www.mattkruse.com/

 

[Harlan Grove]

DATE Name Qty
2/12/04 Bill 2
2/13/04 Bill 4
2/14/04 Joe 8
2/15/04 Bill 3
2/16/04 Mary 5

I want to have a cell containing the MIN() of the quantity column, but
ONLY considering dates later than today (or any given date).

Since quantities can't be negative, and zeros would indicate no matching
records in the table, use the dates in the Date column and the given date as
the condition argument for IF, the quantity column as the True result for
IF, and use no FALSE value for IF. Take the MIN of the result. For example,
use an *array* formula like

=MIN(IF(DateCol>GivenDate,Quantity))

 

[Jonathan Rynd]

(e-mail address removed) (Matt Kruse) wrote in @posting.google.com:

I want to have a cell containing the MIN() of the quantity column, but
ONLY considering dates later than today (or any given date).

Look in to the Database functions (Dfunctions). For example DMIN.