Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

set up →Data→Pivottable...

drag&drop Who into Rowfield, drag&drop Date into Datafield, change Aggregatfunction from sum to max and hit ok

set up →Data→Pivottable...

drag&drop Who into Rowfield, drag&drop Date into Datafield, change Aggregatfunction from sum to max and hit ok

or change your Formula to:

=DMAX('review_log'.$A$1:$B$1003,"Date",A1:A2)