我都服了我自己,居然写完了,努力学习,争取精简
第一题
=SUM(INDEX(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),N(IF({1},SMALL(IF(MATCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),0)=ROW(INDIRECT("1:"&LEN(A2))),ROW(INDIRECT("1:"&LEN(A2)))),ROW(INDIRECT("1:"&COUNT(IF(MATCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),0)=ROW(INDIRECT("1:"&LEN(A2))),ROW(INDIRECT("1:"&LEN(A2)))))))))))*10^(COUNT(IF(MATCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),0)=ROW(INDIRECT("1:"&LEN(A2))),ROW(INDIRECT("1:"&LEN(A2)))))-ROW(INDIRECT("1:"&COUNT(IF(MATCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),0)=ROW(INDIRECT("1:"&LEN(A2))),ROW(INDIRECT("1:"&LEN(A2))))))))) |