Forum Discussion
Randomly Assigning Sales Reps
Hello! - See attached for a sample sheet. I am randomly assigning sales representatives to contacts in a spreadsheet. The trick is that there are multiple contacts under the same account. How can I e...
If I understand what you're asking, I would create a unique list of account names and randomly assign sales reps evenly to the individual accounts.
I think you could use excels randbetween function to assign sales reps, but it would require a circular reference. I attached a workbook as an example with some instructions.