E8:
=IF(B8="值班",IF(B7="值班","",IF(COUNTIF(B8:B13,"值班")=6,6,IF(COUNTIF(B8:B12,"值班")=5,5,IF(COUNTIF(B8:B11,"值班")=4,4,IF(COUNTIF(B8:B10,"值班")=3,3,IF(COUNTIF(B8:B9,"值班")=2,2,"")))))),"")
將公式複製到E8:G38。
H8:
=IF(B8="休",IF(B7="休","",IF(COUNTIF(B8:B13,"休")=6,6,IF(COUNTIF(B8:B12,"休")=5,5,IF(COUNTIF(B8:B11,"休")=4,4,IF(COUNTIF(B8:B10,"休")=3,3,IF(COUNTIF(B8:B9,"休")=2,2,"")))))),"")
將公式複製到H8:J38。
B1:
=COUNTIF(E$8:E$38,ROW()+1)
將公式複製到B1:D5。
F1:
=COUNTIF(H$8:H$38,ROW()+1)
將公式複製到F1:H5。
