- 帖子
- 248
- 主題
- 42
- 精華
- 0
- 積分
- 322
- 點名
- 6
- 作業系統
- XP
- 軟體版本
- Office2007
- 閱讀權限
- 20
- 註冊時間
- 2015-2-20
- 最後登錄
- 2026-5-31
|
回復 1# jeff5424
建立以下輔助
C2=B2&","&B3
D2=TRIM(MID(SUBSTITUTE($C$2,",",REPT(" ",99)),(ROW(A1)-1)*99+1,99))
E2=IF(D2="","",IF(COUNTIF($D$2:D2,D2)=1,VALUE(D2),""))
F2=IFERROR(SMALL($E$2:$E$101,ROW(A1)),"")
G2=IF(F2="","",TEXT(F2,"000"))
H2=G2&IF(G3="","",","&G3)&IF(G4="","",","&G4)&IF(G5="","",","&G5)&IF(G6="","",","&G6)&IF(G7="","",","&G7)&...&IF(G15="","",","&G15)&IF(G16="","",","&G16)&IF(G17="","",","&G17)
顯示合併 B4=H2
|
|
發表於 