排序 括號裡數字 (13214)

C2:G4{=IFERROR(TRIM(MID(SUBSTITUTE($B2,",",REPT(" ",99)),RIGHT(LARGE(IFERROR(MID(SUBSTITUTE(SUBSTITUTE($B2,"(",")"),")",REPT(" ",99)),ROW($1:$9)*198-99,99)/1%+ROW($1:$9),),COLUMN(A1)))*99-98,99)),"")



留言