Thank you in advance for taking a look. I'll start off by saying I cannot attach the workbook due to privacy reasons, so I will do my best to explain the problem I am encountering and hope you can help.
In summary, on one tab I have a list of prospects with the best predicted salesperson per prospect. No salesperson can have more than 20,000 leads. There are 800,000 prospects. Going down the list of prospects, I would like to assign the optimal salesperson unless they have reached their maximum of 20k leads. Then I would like it to assign the second-best. The salespeople are ranked and indexed already on another tab.
How can I execute this type of iterative and dynamic calculation in Excel? Thank you in advance!