Hello looking to solve a problem in excel. Here is an example of my data: Please see attached file.[![enter image description here](https://i.stack.imgur.com/eB7st.png)](https://i.stack.imgur.com/eB7st.png)

I am looking to just grab One barcode to one value(Yes/No) for example if I wanted to see how many Yes answers there are its skewed because you can have multiple Yes/No values per barcode. which would count as 2 instead of just one value. I hope this makes sense. I tried a pivot table and everything because we need to set the barcode to a count distinct but I am lost on how to create a formula or something that would work. I cannot Remove multiple values because each line contains data I need since this is just an example.