E2:E7{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(C$2:C$27=C$2,MATCH(B$2:B$27,B:B,)/1%+ROW($2:$27)),ROW(A1)),2)),"")
F2:F7=IF(E2="","",COUNTIF(E$2:E2,E2))
G2:H7{=IF($E2="","",INDEX($A:$A,SMALL(IF(($B$2:$B$27=$E2)*($C$2:$C$27=IF(G$1=$G$1,$C$2,$C$13)),ROW($2:$27)),$F2)))
I2:I7=IF(E2="","",(H2-G2)*1440)
留言
張貼留言