May 31 2019 01:31 PM
See attached file.
I'm trying to auto-assign some values based on criteria.
Either select PV or TC or LB with certain requirements
I've tried to use =Choose or =RAND but to no avail. Is this even possible to complete?
Jun 06 2019 11:18 AM
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.
Jun 07 2019 02:53 AM