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

2024-11-16 09:57:40
推荐回答(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")
拿去试试。