excel怎么才能随机生成排班表?

2024年11月16日 09:57
有1个网友回答
网友(1):

=CHOOSE(RANDBETWEEN(1,3),"a","b","c")&CHOOSE(RANDBETWEEN(1,3),"d","e","f")&CHOOSE(RANDBETWEEN(1,3),"g","h","i")&CHOOSE(RANDBETWEEN(1,3),"j","k","l")
拿去试试。