| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Latest date with condition
I have 3 columns, example:
Col A Col B Col C Row 1 Name Category of Sale Date of Sale Row 2 Jane 4 07/25/07 Row 3 Jane 5 10/17/07 Row 4 Jane 4 11/11/07 Row 5 Jane 5 06/30/07 I want to bring back the Name (Jane) and latest Date of an invididual's latest sale from a specific category. (Information is not entered in date order.) I have used the array formula {=MAX(IF(A2:A4="Jane",C2:C4))} which gives me the date of Jane's latest sale, nonspecific of which department. Now, how can I bring back 11/11/07 for Jane's latest sale of Category 4? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| latest date | New Users to Excel | |||
| X axis date - display beyond latest date. | Charts and Charting in Excel | |||
| Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
| Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
| sumproduct for latest date | Excel Worksheet Functions | |||
Threaded Mode
