| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| i want to add a number to a date and get the date as an answer eg. | Excel Worksheet Functions | |||
| Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
Linear Mode
