Finding most recent date by customer number

M

Matt Beardsley

I have three columns of data - A is Customer#, B is OrderAmount, C is
OrderDate. What I want to do is create a column on another sheet
"MostRecent" that gives the most recent OrderDate for each Customer#. Data
is currently sorted by OrderDate as that is how the data is entered, no other
sorting between Customer# and OrderAmount.

What is the easiest way to do this? Simple formula? Macro? I have tried
DMAX() and a few others with no success.

Thanks in advance,

MB
 
M

Matt Beardsley

Something close to this worked. Switcing the order of operations for some
reason helped as well as cell referencing the Customer #.

Thanks for the help!
 
Top