隨機出現字符 依指定數 (15205)

B4:AF4=IF((WEEKDAY(EOMONTH($A1,-1)+B2,2)=7)+(B2>DAY(EOMONTH($A1,0))),"",RAND())

B3:AF3=IF(B4="","",IF(RANK(B4,4:4)>SUM(8:8),"",LOOKUP(1,0/FREQUENCY(RANK(B4,4:4),SUBTOTAL(9,OFFSET($C8,,,,COLUMN($A:$E)))),$C7:$H7)&""))

C9:G9=COUNTIF(3:3,C7)

B2:AF2格式化 週日=(WEEKDAY(EOMONTH($A1,-1)+COLUMN(A1),2)=7)*(B2<=DAY(EOMONTH($A1,0)))