V
via135 via OfficeKB.com
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
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