random database text picks, no or only one duplicate
Posted by JB on July 19, 2000 1:55 PM
Question recently came up at work: want to be able to randomly pick a name from an existing database without exceeding duplicating that name more than twice. I can't even figure out how to completely create the formula without duplicating that name once, let alone twice. So if you have a list of say 6 employees and you want to randomly assign them up to two tasks a piece... I have been playing around with the random and database formulas without any luck. Any comments welcome. Thanks.