Forum Discussion
Randomly select rows with criteria-based requirement across multiple columns
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 num...
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.