員工休假時間彙整 (12427)

L2{=INDEX($1:$1,RIGHT(SMALL(IF(($D$3:$G$30="")*($D$4:$G$31<>""),ROW($3:$30)/1%+{4,5,6,7},10099),ROW(A1)),2))&""

M2{=IFERROR(INDEX(A$3:A$30&"/"&B$3:B$30,SMALL(IF((D$3:G$30="")*(D$4:G$31<>"")*(D$1:G$1=L2),ROW($1:$28)),COUNTIF(L$2:L2,L2)))&" 1700~"&INDEX(A$3:A$31&"/"&B$3:B$31,SMALL(IF((D$3:G$30<>"")*(D$4:G$31="")*(D$1:G$1=L2),ROW($2:$29)),COUNTIF(L$2:L2,L2)))&" 0800","")