first of all sorry for the clumsy title...
I think it's easiest to look at the example sheet when I explain my problem.
I have a list of pairs (triples or even more) in column A. All the units that belong together have the same ID. So in the example A and J are a pair.
Now I have a list (column F).
What I want is to add a "1" in column C for all the units that belong to pairs where at least one unit is on the list. I have hard coded the desired result in column D.
Does anyone have a simple formula (the sheet is huge in reality) to solve this?
Thanks a lot in advance!