各位Excel大神,怎么能求出张三李四等的每次住院出院的间隔时间?_百度...答:C2=IF(COUNTIF($A$2:A2,A2)=1,"",INDEX(B:B,SMALL(IF($A$2:$A$1000=A2,ROW($A$2:$A$1000),65536),COUNTIF($A$2:A2,A2)))-INDEX(B:B,SMALL(IF($A$2:$A$1000=A2,ROW($A$2:$A$1000),65536),COUNTIF($A$2:A2,A2)-1)))数组公式 需要同时按 ctrl shift 回车键...