本帖最后由 LSL1128xgw 于 2019-11-7 10:52 编辑
=SUM(IFERROR(-SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MIDB(A2&A3&A4&A5&A6,ROW(1:801),FREQUENCY(-ROW(1:800),-(MMULT(1+ISERR(-MIDB(0&A2&A3&A4&A5&A6,ROW(1:800)+{0,1,2)),{5;1)=7)*ROW(1:800))),"收",),"放","-"),C1:F1,),)*-C10:F10) 215字符
=SUM(-IFERROR(-RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A2&A3&A4&A5&A6,ISERR(-(MID(A2&A3&A4&A5&A6&"a",ROW(2:801),1)&0))*ROW(1:800)),"收",),"放","-"),C1:F1,REPT(" ",30)),30),)*C10:F10) 184字符
=SUM(-IFERROR(-RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A2&A3&A4&A5&A6,(MID(A2&A3&A4&A5&A6&"啊",ROW(2:801),1)&0>"啊")*ROW(1:800)),"收",),"放","-"),C1:F1,REPT(" ",30)),30),)*C10:F10) 180字符
=SUM(-IFERROR(-RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2&A3&A4&A5&A6,(MID(A2&A3&A4&A5&A6&"啊",ROW(2:801),1)&0>"啊")*ROW(1:800)),"放","收-"),C1:F1&"收",REPT(" ",30)),30),)*C10:F10) 168字符
=SUM(TEXT(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2&A3&A4&A5&A6,(MID(A2&A3&A4&A5&A6&"啊",ROW(2:801),1)&0>"啊")*ROW(1:800)),"放","收-"),C1:F1&"收",REPT(" ",30)),30),"0.00000;-0.00000;;\0")*C10:F10) 185 字符 03版
=SUM(TEXT(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2&A3&A4&A5&A6,(MID(A2&A3&A4&A5&A6&"啊",ROW(2:801),1)&0>"啊")*ROW(1:800)),"放","收-"),C1:F1&"收",REPT(" ",30)),30),"[<>];;;\0")*C10:F10) 此浮点问题,各位可以看下具体原因
思路一步步逐步转换,简化,最终03版本可适用。MID(A2&A3&A4&A5&A6&"座",ROW(2:801),1)>"啊" 此部分简化,再简化2个字符
|