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.
