Forum Discussion

Januszmedz's avatar
Januszmedz
Copper Contributor
Mar 06, 2024

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