SHEET2表: A3=INDEX(Sheet1!A:A,SMALL(IF(MATCH(Sheet1!$B$3:$B$25,Sheet1!$B$3:$B$25,)=ROW($1:$23),ROW($3:$25),65536),ROW(1:1)))&"" SHEET3表: A3=INDEX(Sheet1!A:A,SMALL(IF(MATCH(T(OFFSET(Sheet1!$B$2,24-ROW($1:$23),)),T(OFFSET(Sheet1!$B$2,24-ROW($1:$23),)),)=ROW($1:$23),26-ROW($1:$23),65536),ROW(1:1)))&"" 均为数组公式,向右向下复制.
3ryjRawk.rar
(16.23 KB, 下载次数: 0)
|