Excel 2007 use array formula to flag conditional data

[ysuee]

Hey All,

Here's my problem:

I need to "Flag" each of the rows above that meet the following conditions:

ALL PARTs that have a CATEGORY of "B", but not "A", keeping in mind that there are duplicate parts within the list. Here's an example:

So, the output of the data above would yield:

I had an array formula working earlier using a SUM and IF statement within an array formula but can't seem to replicate it. I attached the data as reference.

Can anyone help me create the formula to "Flag" the above rows if the conditions are met?




thanks

[zbor]

maybe this:

=IF(B2="A",0,SUMPRODUCT(--($A$2:$A$100=A2),--($B$2:$B$100="B")))