Randomly select rows with criteria-based requirement across multiple columns

Copper Contributor

See attached file. 

 

I'm trying to auto-assign some values based on criteria. 

 

Either select PV or TC or LB with certain requirements

  • Have at least 14 columns with reps
  • Assign a certain number of PV or TC at certain times of the day. The overflow would be auto-assigned to TC or LB
  • LB is only assigned at certain times
  • IF LB equals 0, no need to assign

I've tried to use =Choose or =RAND but to no avail. Is this even possible to complete? 

2 Replies

UPDATE: So I have this thus far: =CHOOSE(RANDBETWEEN(1,2), "PV", "TC") 

If I could choose PV or TC based on a criteria e.g. only assign 4 PV but randomly choose between PV or TC until 4 PV are assigned, then that would be perfect. Then all the overflow would be TC.

Again, Idk if this is possible but I'm a lot closer than where I was before. Appreciate any help or guidance. 

You must manually enter your desired results, then explain how you determined each so that the logic of the required formula may come to light.