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 we assume Casper Heating is Account ID 1, then the formula would be broken in two sections
Cell A2 would be the start with no condition:
=INDEX($F$4:$F$6,RANDBETWEEN(1,ROWS($F$4:$F$6)),1)
Every cell after A2 would have the condition to review previous results:
=IF(D3=D2,A2,INDEX($F$4:$F$6,RANDBETWEEN(1,ROWS($F$4:$F$6)),1))
An important note is that two new columns should be made to finalize the dataset.
1. TRIM the Account Names to make the data uniformed and automatically remove additional white spaces
2. Account IDs that you link using VLOOKUP or INDEX/MATCH to get the reference for the IF syntax