Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show latest date
So I have a spreadsheet that looks like the following
Column A is customers Row A is dates (365 of them) Each day I log which customers I contact by placing a T, VM, E, or M in the appropriate row and column. I column B, I want to show the latest date that the customer was contacted. In column C I want to show how they were contacted (T, VM, E, or M). I tried some if, then combinations, but am not having much luck. Can anyone assist? I am grateful as always for this group and for its very intelligent members. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show latest date in a column | Excel Discussion (Misc queries) | |||
Filter latest date from multiple date entries | Excel Worksheet Functions | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
show latest date input only | Excel Discussion (Misc queries) | |||
Show only latest Date of Service? | Excel Worksheet Functions |