Finding most recent date by customer number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try:

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

entered with Ctrl+Shift+Enter

HTH
 
Try:

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

entered with Ctrl+Shift+Enter

HTH
 
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!
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding most recent date for each customer - XL 2007 2
custom data validation on cells with data validation values 2
Sorting day names chronologically 5
Count my Customers 4
Custom Sort Order - Wildcard? 1
how to fill in names in cells automatically 2
Max Date Function and unbound text field 5
How to pull in rows based on Column A data? 2

Back
Top