Hello everyone: new here Thanks in advance

Goal: I need to return the latest date a manager co-travelled with a Sales Rep.

I created a basic calendar, stating in Cell A3 I put all calendar dates running down column A.  I then have 13 reps starting in cell B2 – N2 (running across row 2).  All of the cells within are drop down menus containing the names of the same 5 managers.  

I need to know when the last time a manager co-travelled with a Sales Rep.  Knowing that a manager can co-travel with a single rep more then one time through out the year.

Thoughts?

Thanks

Steve

​Hello everyone: new here Thanks in advance Goal: I need to return the latest date a manager co-travelled with a Sales Rep. I created a basic calendar, stating in Cell A3 I put all calendar dates running down column A.  I then have 13 reps starting in cell B2 – N2 (running across row 2).  All of the cells within are drop down menus containing the names of the same 5 managers.   I need to know when the last time a manager co-travelled with a Sales Rep.  Knowing that a manager can co-travel with a single rep more then one time through out the year. Thoughts? ThanksSteve  Read More

​