| 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 |
| 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) | |||
Threaded Mode
