按問卷選項 出現次序 D2 右拉 下拉{=IFERROR(IF($A$1=A$1,"","|")&INDEX(TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE($A2,"|"," "))," ",REPT(" ",99)),ROW($1:$9)*99-98,99)),SMALL(IF((MATCH(TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE($A2,"|"," "))," ",REPT(" ",99)),ROW($1:$9)*99-98,99)),TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE($A2,"|"," "))," ",REPT(" ",99)),ROW($1:$9)*99-98,99)),)=ROW($1:$9))*(TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE($A2,"|"," "))," ",REPT(" ",99)),ROW($1:$9)*99-98,99))<>""),ROW($1:$9),99),COLUMN(A1)))&E2,"")
按設定選項 出現次序 D9 右拉 下拉=IFERROR(IF($A$1=A$1,"","|")&INDEX({"Efficacy";"Price";"Safety"},SMALL(IF(1-ISERR(FIND({"Efficacy";"Price";"Safety"},$A2)),ROW($1:$3)),COLUMN(A1)))&E9,"")
問卷選項少 可以 無須右拉=MID(IF(COUNTIF(A2,"*Ef*"),"|Efficacy","")&IF(COUNTIF(A2,"*Pr*"),"|Price","")&IF(COUNTIF(A2,"*Sa*"),"|Safety",""),2,30)
留言
張貼留言