F2数组公式下拉:- =INDEX(A:A,MIN(IF(COUNTIF($F$1:F1,A$2:A$25),4^8,ROW($2:$25))))&""
复制代码 G2数组公式右下拉:- =INDIRECT(TEXT(INDEX(SMALL(IF($A$2:$A$25=$F2,ROW($2:$25)*10^3+{2,3},6^10),ROW($1:$30)),SMALL(IF(MATCH(RIGHT(TEXT(TRUNC(SMALL(IF($A$2:$A$25=$F2,ROW($2:$25)/1%%+{2,3}/1%+$B$2:$C$25,10^9-1),ROW($1:$30)),3),"0.000"),3),RIGHT(TEXT(TRUNC(SMALL(IF($A$2:$A$25=$F2,ROW($2:$25)/1%%+{2,3}/1%+$B$2:$C$25,10^9-1),ROW($1:$30)),3),"0.000"),3),)=ROW($1:$30),ROW($1:$30),30),COLUMN(A1))),"R0C000"),)&""
复制代码 |