Forum Discussion
Januszmedz
Mar 06, 2024Copper Contributor
Need help with randomizing positions in a work planner
Hi guys, I'm trying to make a work planner that shuffles the positions of each employee on a line. I have the original list, where I assign the employees onto the line, and then I use the RANDARRAY to assign them a random number.
In column D, I use the SORTBY to sort the employees from position 1 and up, for when I have empty positions, it sorts the zeros at the bottom.
Column E just matches their names with their working ID in D.
I got it working, but how do I randomize everyone between position 2-14 by eachother, and position 1, 15, 16 by eachother?
No RepliesBe the first to reply