|
加入A1:A12为2，6，7，9，8，2，1，3，6，5，4，2在B1输入=IF(ISERROR(SMALL(IF($A$1:$A$12=A1,ROW($A$1:$A$12),"0"),COUNTIF($A$1:A1,A1)+1)-SMALL(IF($A$1:$A$12=A1,ROW($A$1:$A$12),"0"),COUNTIF($A$1:A1,A1))),"",SMALL(IF($A$1:$A$12=A1,ROW($A$1:$A$12),"0"),COUNTIF($A$1:A1,A1)+1)-SMALL(IF($A$1:$A$12=A1,ROW($A$1:$A$12),"0"),COUNTIF($A$1:A1,A1)))按Ctrl+Shift+Enter三键结束公式，然后下拉 |
