The original file expands for the entire year, but ofc only limited data is provided. I need to use the date column to find the most recent agent attached to a customer.
The original file expands for the entire year, but ofc only limited data is provided. I need to use the date column to find the most recent agent attached to a customer.
Not sure where you wanted the list of most recent (MR) agents so I set up a small range in columns AD:AF of customers, MR dates and MR agents. The array entered formula* for the MR agents column is:*activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Fantastico, that did it. Thank you much good sir.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks