Correction:

THIS:
CD1: test
CD: =SUMPRODUCT(($CB$2:$CB$18=CB2)*$CC$2:$CC$18)=0

SHOULD BE:
CE1: test
CE2: =SUMPRODUCT(($CB$2:$CB$18=CB2)*$CC$2:$CC$18)=0

My appologies for the typos.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ron Coderre" wrote:

Well, I completely misinterpreted what you are looking for:

Try this:
CD1: test
CD: =SUMPRODUCT(($CB$2:$CB$18=CB2)*$CC$2:$CC$18)=0

Select your data list CA1:CB1000
DataFilterAdvanced Filter
List Range: (your already selected list)
Criteria Range: $CE$1:$CE$2
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ron Coderre" wrote:

Try this:
Make sure your data has column headings above the actual data.
Select your entire data list (including the headings)
DataFilterAutoFilter
Click the dropdown list in Col_CB
Select 0 <-zero (your example indicates you want zero values)

The list should now hide all rows where Col_CB does not = zero.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"a_moron" wrote:


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