eliminating records!

  • Thread starter via135 via OfficeKB.com
  • Start date
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
 
V

via135 via OfficeKB.com

reminding again for help!

-via135

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top