在H3单元格输入以下公式,然后向右向下填充公式
=IF(COUNTIF(OFFSET($B$2:$F$2,COUNT($B$1:$B$200)-19+ROW(A1)-1,),H$1)>0,H$1,"")
或=IF(COUNTIF(OFFSET($B$2:$F$2,COUNT($B$1:$B$200)-19+ROW(A1)-1,),H$1)>0,H$1,0)
H2=IF(COUNTIF(OFFSET(INDIRECT(ADDRESS(LOOKUP(1,0/($B$2:$B$998<>"")*ROW($B$2:$B$998),ROW($B$2:$B$998))-20+ROW(A1),2)),0,0,1,5),H$1),H$1,0)向下向右复制