單元格數字遞增減 判斷 (13642)

B2=MID("INDNNNNNN",SUM((FREQUENCY(SIGN(MMULT(MID(SUBSTITUTE(A2,",",REPT(" ",99)),(ROW(INDIRECT("1:"&LEN(A2)-LEN(SUBSTITUTE(A2,",",))))+{0,1})*99-98,99)*1,{1;-1})),{-1,0,1})>0)*{1;3;5;7}),1)



留言