C3{=MAX(--(0&TRIM(MID(SUBSTITUTE(SUBSTITUTE(D3,"長","、"),"、",REPT(" ",199)),ROW($1:$9)*398-198,199))))
另解{=MAX(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(D3,"長","、"),"、",REPT(" ",199)),(ROW($1:$9)*2-1)*199,199)*1,))
另解{=MAX(RIGHT(LARGE(IFERROR(MID(D3,SMALL(IF(MID(D3,ROW($1:$199),1)="長",ROW($1:$199)),ROW($1:$9))+1,COLUMN(A:I))*1,)+ROW($1:$9)*10^8,ROW($1:$9)*9-8),8)*1)
另解{=MAX(--TEXT(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(D3,"長","、長"),"、",REPT(" ",99)&"|"),ROW($1:$19)*99-98,99),"|長",),"[>0];0;0;!0"))
留言
張貼留言