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