D2{=SUM(RIGHT(SMALL(IFERROR(MID(A$2:A$5,FIND(C2,A$2:A$5)+LEN(C2)+1,COLUMN(A:I))*1,)+ROW(2:5)*10^9,ROW($1:$4)*9),9)*1)
水果不重複=-LOOKUP(,-MID(PHONETIC($A$2:$A$5),FIND(C2,PHONETIC($A$2:$A$5))+LEN(C2)+1,ROW($1:$5)))
另解{=SUM(IFERROR(TRIM(LEFT(SUBSTITUTE(MID(A$2:A$6,FIND(C2,A$2:A$6)+LEN(C2)+1,99),"斤",REPT(" ",50)),50))/1,))
留言
張貼留言