advise pls
 

hi all excel gurus....

can some one pls advise me if it possible to identify numbers in pairs
that sum up to become 0?

i have data like

a)-30
b)56
c)30
d)78
e)-90
f)-30
g) -10
h)-9
i) 45
j)10
k)30
L)9
my ans are
as u can see (a) and (C) & (f) and (k) , h&L and g&i

each number can only be used once
can some one help?
thanks

advise pls
 

If A1 thru B12 contain:
a -30
b 56
c 30
d 78
e -90
f -30
g -10
h -9
i 45
j 10
k 30
L 9
then enter and run:
Sub gary()
For i = 1 To 11
For j = i + 1 To 12
If Cells(i, 2).Value + Cells(j, 2).Value = 0 Then
MsgBox (Cells(i, 1).Value & Cells(j, 1).Value)
End If
Next
Next
End Sub

--
Gary''s Student


"Hopeless With excel" wrote:

hi all excel gurus....

can some one pls advise me if it possible to identify numbers in pairs
that sum up to become 0?

i have data like

a)-30
b)56
c)30
d)78
e)-90
f)-30
g) -10
h)-9
i) 45
j)10
k)30
L)9
my ans are
as u can see (a) and (C) & (f) and (k) , h&L and g&i

each number can only be used once
can some one help?
thanks