hi!
The simplest solution is pivot table.


"via135 via OfficeKB.com дµÀ£º
"
hi!
sorry..the data in my earlier post
was wrong and the correct one is
as follows:

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 flag off the record nos

1,5,8 & 9 the subtotal of the flagged records
should be always zero!


and able to retain the remaining records!

-via135

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