Quote:
Originally Posted by xor
Can you accept that numbers are entered in for example rows 2:6 and then the corresponding names appear in rows 24:28?
|
Sure, I'm looking for the solution, so I can try any suggestion.
I've tried =INDEX($Q$1:$Q$14,MRAND()+1) functions, but notice it repeats ppl on the same task on the following day...so this is no good.