advise pls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hopeless With excel - 22 Jan 2006 15:49 GMT

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

Reply to this Message

Gary''s Student - 22 Jan 2006 16:49 GMT

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

Signature

Gary''s Student

> hi all excel gurus....
>
[quoted text clipped - 21 lines]
> can some one help?
> thanks

Reply to this Message