Using DMAX


Posted by Samuel John Shoptaw on August 21, 2001 7:08 AM

I have two worksheet in the same document. Product “A” is listed in worksheets ”A” one time and in worksheet “B”, is listed multiple times with dates. In worksheet “A” next to product “A” I have a cell, which I would like to insert a formula (DMAX). I need help in writing the formula. Can someone help me?

Posted by Mark W. on August 21, 2001 7:12 AM

Are you trying to find the MAX date?

Posted by Samuel John Shoptaw on August 21, 2001 7:21 AM

Yes, Im looking for max date.



Posted by Mark W. on August 21, 2001 7:32 AM

Suppose B!A1:B4 contains...

{"Field1","Field2"
;"Product A",37124
;"Product A",37125
;"Product A",37123}

...and A!A1 contains "Product A". Enter the
formula, =DMAX(B!A1:B4,"Field2",A!D1:D2), into
cell B1. If your list on worksheet B contains
products other than A then specify Product A
only in criteria range, A!D1:D2, by entering
{"Field1"; "Product A"} into these cells.