You need to use a helper column of formulas: in CC2, for example, use one of these formulas

=SUMIF(CA:CA,CA2,CB:CB)=0

=SUMPRODUCT(($CA$2:$CA$1000=CA2*$CB$2:$CB$1000=1)) =0

depending on whether you only have 1's and 0's or other numbers...

Then copy them down to match you column, and filter on CC for TRUE.

HTH,
Bernie
MS Excel MVP


"a_moron" wrote in message
...

Is this possible to do?

The result I want is to filter _ALL_ common (group of) values column
*CA* that has the value 1 in column *CB*
Code:
--------------------
CA CB
----------
A 0
A 0
A 1
A 0
B 1
C 0
C 0
C 0
D 0
D 0
D 1
E 1
E 1
F 0
F 0
F 0
F 0
--------------------
So the result would look something like this:
Code:
--------------------
CA CB
----------
C 0
C 0
C 0
F 0
F 0
F 0
F 0
--------------------


--
a_moron


------------------------------------------------------------------------
a_moron's Profile: http://www.excelforum.com/member.php...o&userid=30671
View this thread: http://www.excelforum.com/showthread...hreadid=503300