如何在Excel中的列表中找到两个数字的所有可能和？

Sub Combinations() UpdatebyExtendoffice20180628 Dim xRgArr Dim xNum As Long Dim I, J, K As Long Dim xTemp As Double Dim xRg As Range Dim xRgCount As Long Dim xDic As New Dictionary On Error Resume Next Set xRg = Application.InputBox("Select a list (one column):", "KuTools for Excel", Selection.Address, , , , , 8) If (xRg Is Nothing) Or (xRg.Count = 1) Then Exit Sub xRgCount = xRg.Count K = 1 ReDim xRgArr(1 To xRgCount) For Each xCell In xRg xRgArr(K) = xCell.Value K = K + 1 Next K = 0 For I = 1 To xRgCount For J = I + 1 To xRgCount xTemp = xRgArr(I) + xRgArr(J) If Not xDic.Exists(xTemp) Then xDic.Add CDbl(xTemp), CStr(xTemp) K = K + 1 End If Next Next Range("C1").Resize(xDic.Count, 1) = Application.WorksheetFunction.Transpose(xDic.Keys) End Sub

Kutools for Excel, 与超过 300 方便的功能，使您的工作更加轻松。