Forum Discussion
lucaspaul
Jan 22, 2020Copper Contributor
If funktion alphabetical assignments
Hello everyone, First of: first post and not a native english speaker so please excuse my mistakes. Basically I have a giant sheet with a lot of customer names. These customers need to be alphabe...
PascalKTeam
Jan 23, 2020Iron Contributor
Hi lucaspaul
Please take a look at attached file and tell me if this is what you need. it's not the smartest and most dynamic solution but if it works, it works 🙂
You can enter new customers in column A and the sales person from the table on the right will be assigned. For each sales person you can assigned a FROM and TO letter from the alphabet