|
发表于 2014-9-19 08:22
|
显示全部楼层
本楼为最佳答案
本帖最后由 baksy 于 2014-9-19 10:42 编辑
A梦-Doraemon 发表于 2014-9-18 19:32
好像不对啊。。得出来的答案都是0 大侠
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(TEXT(SUM(IF(MID(A1,ROW($1:$15),1)=B1&"",ROW($1:$15))*10^(15-ROW($1:$15))),REPT("0 ",15)))," ",","),"0,",""),",1,",",1"),",0","")
必须三键回车!!!(点击公式编辑栏中的任意位置,按住 shift、ctrl 两个键,然后敲enter键 ),
312345335632321 | 3 | 1,4,7,8,11,13 | abcabcdefdef | b | 2,5 | 一二三四四三二一 | 三 | 3,6 |
|
|