excel怎么把一个数据区域里的数据全部复制？

Question

如题所述

Answer 1

如图，A3=IF(C3="","",A2+1+(MIN(IF($C$2:$C$40>--"16:00:00",$C$2:$C$40,999))=C3)*RANDBETWEEN(4,7))

数组公式，下拉复制

B2="07:00:00"+("00:"&TEXT(RANDBETWEEN(15,30),"00")&":"&TEXT(RANDBETWEEN(1,60),"00"))

B3=B2+("00:"&TEXT(RANDBETWEEN(15,30),"00")&":"&TEXT(RANDBETWEEN(1,60),"00"))

下拉复制

C2=IF(B2+5/24>19.5/24,"",B2+IF(B2>=(11/24),5/24,0))   

下拉复制

然后把B列隐藏起来，如图

按F9重新计算