Dynamic Calculation Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1322262%22%20slang%3D%22en-US%22%3EDynamic%20Calculation%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1322262%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20taking%20a%20look.%20I'll%20start%20off%20by%20saying%20I%20cannot%20attach%20the%20workbook%20due%20to%20privacy%20reasons%2C%20so%20I%20will%20do%20my%20best%20to%20explain%20the%20problem%20I%20am%20encountering%20and%20hope%20you%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20summary%2C%20on%20one%20tab%20I%20have%20a%20list%20of%20prospects%20with%20the%20best%20predicted%20salesperson%20per%20prospect.%20No%20salesperson%20can%20have%20more%20than%2020%2C000%20leads.%20There%20are%20800%2C000%20prospects.%20Going%20down%20the%20list%20of%20prospects%2C%20I%20would%20like%20to%20assign%20the%20optimal%20salesperson%26nbsp%3B%3CSTRONG%3Eunless%3C%2FSTRONG%3E%20they%20have%20reached%20their%20maximum%20of%2020k%20leads.%20Then%20I%20would%20like%20it%20to%20assign%20the%20second-best.%20The%20salespeople%20are%20ranked%20and%20indexed%20already%20on%20another%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20execute%20this%20type%20of%20iterative%20and%20dynamic%20calculation%20in%20Excel%3F%26nbsp%3B%3CSTRONG%3EThank%20you%20in%20advance!%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1322262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello all!

 

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!

0 Replies