hi Roger!

i am getting the following results:

111 50 1
112 100 1
113 -50 1
114 -100 1
111 -50 1
115 150 1
112 -50 1
114 50 2
114 -50 2
113 100 1

-via135

Roger Govier wrote:
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

hi!

[quoted text clipped - 13 lines]

-via135

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