| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Max Date and the value
I was wondering if this is possible in Excel 2007.
I have six columns of data,starting in columns AB labeled as follows: Note column placements may change as data is added. Letter Sent#1 - this has a "Yes" or "" Value Letter Sent Date - Date Value Letter Sent #2 - this has a "Yes' or "" Value Letter Sent Date - Date Value Letter Sent # 3 - this has a "Yes" or "" Value Letter Sent Date - Date Value I need to look at each date value and find the most recent and then pull in which it was; Letter Sent #1, or #2 or #3? Also if I need to change the format in the future for the Letter Sent #1, #2 and #3 to values such as "Yes' or "No" instead "Yes" or "". Would the formula provided need updated or would it not matter since it is loking at the maximum date first? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using formula to find out a Date 90 prior to a particular date | Excel Worksheet Functions | |||
| Find Specific date in Biwwekly Based on date | Excel Discussion (Misc queries) | |||
| Julian date - find next highest date/number | Excel Worksheet Functions | |||
| Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions | |||
| Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
Threaded Mode
