Dealing with alternative codes

Hi,

I am having some product codes in column E and alternatives if existing in another column( Column C).

If there is no two alternatives for one code nothing happens(either only 1 or only 2). If There is alternative 1 and 2 for one code, id like to delete those with alternative number 1. I assume that the best way is to insert additional column with output as 1 or 0 .

I am attaching what i have at the moment.
2022-02-25_10h24_49.png



And there is desired output (Column N). Maybe there is a better way to solve this.
2022-02-25_10h30_58.png




Thanks in advance !

Hi Glenn,

Thanks for clarification. I've attached sample with desired output and some explanation.

Appreciate any help !