(11595) 各姓名顯最小到最大連續日期

E2:M16{=IF(COUNTIF($D$2:$D2,$D2)=1,IFERROR(SMALL(ROW(INDIRECT(MIN(IF($D$2:$D$16=$D2,$A$2:$A$16))&":"&MAX(IF($D$2:$D$16=$D2,$A$2:$A$16)))),COLUMN(A1)),""),"")

O2{=IFERROR(RIGHT(SMALL(IF(E$2:M$16<>"",ROW(2:16)*10^8+E$2:M$16),ROW(A1)),8)*1,"")