Hi

One way
In cell C2 enter the following and copy down
=SUMPRODUCT(($A$2:$A$11=A2)*($B$2:$B$11=-B2))
There will be 1's against the matching items and 0's against the rest.
DataFilterAutofilteruse dropdown on column C to select rows with 1

--
Regards

Roger Govier


"via135 via OfficeKB.com" <u23552@uwe wrote in message
news:693b3ffc4e3e6@uwe...
hi!

i don't think so!

any other help pl?

-via135
wrote:
hi!
The simplest solution is pivot table.

"via135 via OfficeKB.com ??:
"
hi!
sorry..the data in my earlier post
[quoted text clipped - 29 lines]

-via135

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