Randomly select rows with criteria-based requirement across multiple columns

[markraymond]

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]

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. 

[#3]

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.