Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here's what I'm looking at:
I've got a data set which pairs a customer with the dates that customer has ordered, looking like this: Customer # Order date 1 3/5/06 1 4/12/06 1 5/19/06 2 1/3/06 2 4/5/06 3 2/12/06 3 3/19/06 3 5/22/06 And so forth. Its a very long list. I need to write a function with the customer number as an input (the subgroup) which finds the most recent order date (the max) and returns that date, so the output would look like this: Customer # Most Recent Order 1 5/19/06 2 4/5/06 3 5/22/06 Thanks in advance for your help, JC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Asymptotes from a set of data in Excel | Excel Worksheet Functions | |||
Finding Asymptotes from a set of data in Excel | Excel Discussion (Misc queries) | |||
Finding the maximum of a subset of values on a different sheet | Excel Discussion (Misc queries) | |||
Finding text within text | New Users to Excel | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) |