Amedee,

Your array formula was checking the dates against $A13695, so you can just
put =$A13695 in K2, that is what I did in my test, it does not have to be a
static value (It could even be the result of a formula, i.e. an expression).

--

HTH

Bob

"Amedee Van Gasse" wrote in message
...
On 7 apr, 17:04, "Bob Phillips" wrote:
I would say it is a good way to go, but you do have to setup the criteria
as
a separate table. But that is good IMO, as you have the criteria clearly
defined, visible and auditable, not embedded in a formula.

Plus, you don't have to worry about ranges, you can use the whole
columns,
=DMAX(A:B,"Amt",K1:K2)

One other thing, the master data has to have headings.

Hi Bob,

No problem with the headings.

K1 is obviously the same as the heading of column A, "Date".
But I am really confused about what I should put in K2.

Perhaps I should mention that I don't need this DMAX value one time,
but on every row, depending on the current value in column A.