|
在G2输入公式=IF(ISERROR(INDEX($A$2:$A$12,SMALL(IF(MATCH(A$2:A$12,A$2:A$12,)=ROW($2:$12)-1,ROW($2:$12)-1),ROW(A1)))&""),"",INDEX($A$2:$A$12,SMALL(IF(MATCH(A$2:A$12,A$2:A$12,)=ROW($2:$12)-1,ROW($2:$12)-1),ROW(A1)))&"")
三键结束,下拉至G12
然后在G13里面输入:
=COUNTA(G2:G12)-COUNTBLANK(G2:G12) |
|