假设C1=001,D1=2下面公式找到C1的D1次出现的行号,找不到时返回9999=SMALL((($A$2:$A$8=$C$1)*ROW($A$2:$A$8)+($A$2:$A$8<>$C$1)*9999),D1)
="第 " & COUNTIF($A$1:A1,A1) & " 次"
B1=IF(A1="001",TEXT(COUNTIF($A$1:A1,"001"),"[dbnum1]第#次"),"")