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