隨機分配不重複各部门人員 (12197)

B2:B19{=OFFSET(F$1,MATCH(A2,F:F,)-1,SMALL(IF((F$2:F$4=A2)*(G$2:M$4<>"")*(COUNTIF(B$1:B1,G$2:M$4)=0),COLUMN(A:G)),RANDBETWEEN(1,COUNT(0/(F$2:F$4=A2)/(G$2:M$4<>""))-COUNTIF(A$1:A1,A2))))

D2{=AND(COUNTIF(G:M,B2:B19)=1)