Finding most recent date by customer number
 

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

Finding most recent date by customer number
 

Try:

=MAX((C2:C100)*(A2:A100="Customer1"))

entered with Ctrl+Shift+Enter

HTH

"Matt Beardsley" wrote:

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

Finding most recent date by customer number
 

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!

"Toppers" wrote:

Try:

=MAX((C2:C100)*(A2:A100="Customer1"))

entered with Ctrl+Shift+Enter

HTH

"Matt Beardsley" wrote:

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