標題: [發問] excel 公式 數字合併問題 [打印本頁]

---

作者: jeff5424    時間: 2026-5-7 21:16     標題: excel 公式 數字合併問題

請教各位高手大大

如何使用公式將B2欄位及B3欄位數字
使用公式在B4欄位合併
數子不重複及數子由小至大排列
如B4欄位所示
說明如附件所示

---

作者: cypd    時間: 2026-6-1 00:45

回復 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
[attach]38459[/attach]

---

作者: hcm19522    時間: 2026-6-1 16:12

(搜尋 輸入號碼 15076) google網址:https://hcm19522.blogspot.com/

---

歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)