|
发表于 2017-4-11 18:21
|
显示全部楼层
本楼为最佳答案
就示例数据- =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,INDEX(G:G,LARGE((1-ISERR(FIND(G$2:G$21,A2)))*ROW($2:$21),1)),INDEX(F:F,LARGE((1-ISERR(FIND(G$2:G$21,A2)))*ROW($2:$21),1))),INDEX(G:G,LARGE((1-ISERR(FIND(G$2:G$21,A2)))*ROW($2:$21),2)),INDEX(F:F,LARGE((1-ISERR(FIND(G$2:G$21,A2)))*ROW($2:$21),2))),INDEX(G:G,LARGE((1-ISERR(FIND(G$2:G$21,A2)))*ROW($2:$21),3)),INDEX(F:F,LARGE((1-ISERR(FIND(G$2:G$21,A2)))*ROW($2:$21),3)))
复制代码 数组公式下拉
|
|