陣列 A: ["A","B","A"],陣列 B: [1,2,3]。
輸出:A 4 (1+3), B 2。
a = Split("A,B,A", ",")
b = Split("1,2,3", ",")
For i = 0 To UBound(a)
For j = i + 1 To UBound(a)
If a(i) <> "" And a(i) = a(j) Then
a(j) = "" ' 標記重複項清空
b(i) = CInt(b(i)) + CInt(b(j)) ' 合併數值
b(j) = 0
Exit For
End If
Next
Next
For i = 0 To UBound(a)
If a(i) <> "" Then MsgBox a(i) & " " & b(i)
Next
const a = ["A","B","A"];
const b = [1,2,3];
const map = new Map();
a.forEach((v,i) => map.set(v, (map.get(v)||0) + b[i]));
for (const [k,v] of map) console.log(k, v); // A 4, B 2