hi!

i'm having some id in colA
& numbers (may be "+" or "-") in colB
as under!
how can i eliminate the matched pairs
of "+" & "-" with ref to the id in colA?


-sample data-
colA colB
111 50
112 100
113 -50
114 -100
111 -50
115 150
112 -50
114 50
114 -50
113 100

what i want is using some formula in colC
can i eliminate the record nos
2,4,6,9,10 & 11

111 50
113 -50
111 -50
114 50
114 -50
113 50

and able to get the remaining
records as under:

112 100
114 -100
115 150
112 -50


any help pl?

-via135

--
Message posted via http://www.officekb.com

reminding again for help!

-via135


via135 wrote:
hi!

i'm having some id in colA
& numbers (may be "+" or "-") in colB
as under!
how can i eliminate the matched pairs
of "+" & "-" with ref to the id in colA?

-sample data-
colA colB
111 50
112 100
113 -50
114 -100
111 -50
115 150
112 -50
114 50
114 -50
113 100

what i want is using some formula in colC
can i eliminate the record nos
2,4,6,9,10 & 11

111 50
113 -50
111 -50
114 50
114 -50
113 50

and able to get the remaining
records as under:

112 100
114 -100
115 150
112 -50

any help pl?

-via135

--
Message posted via http://www.officekb.com

?????!!!!!!!
-via135

via135 wrote:
reminding again for help!

-via135

hi!

[quoted text clipped - 39 lines]

-via135

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1