|
妹纸 发表于 2014-12-2 11:49
貌似不对呢 - =TEXT(SMALL(IF(ISNA(MATCH(ROW($1:$50)*2,2^ROW($1:$50),)),ROW($1:$50)*2,999),ROW(A1)),"[<999];")
复制代码- =IF(51-COUNT(MATCH(ROW($1:$50)*2,2^ROW($1:$50),))>ROW(A1),SMALL(IF(ISNA(MATCH(ROW($1:$50)*2,2^ROW($1:$50),)),ROW($1:$50)*2),ROW(A1)),"")
复制代码 |
|