Hello Excel Peeps - This is for excel 2010.
I attached test workbook is working as needed with kudos going out to @Ace_XL and @nflsales (Thanks for getting me up and running)
However at the time @nflsales asked me a question
When I answered him I had forgotten that there are times when Advisors could move locations through out the year.
So I need a small tweak or two to the formulas in this workbook to accommodate the situation when an advisor moves locations.
In the test book I have added more info to explain expected result when an advisor moves locations.
See blue box on cases tab first
Then see blue box(s) on Advisor NPS tab.
Let me know if you have any questions to help resolve.
And Thank You in advance.
Bookmarks