Show latest date
On Thursday, October 4, 2012 3:49:50 PM UTC-4, Don Guillett wrote:
On Thursday, October 4, 2012 8:29:48 AM UTC-5, McClellan wrote:
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.
Hard to see your layout. provide a file
Ok. How do I attach a file?
|