Search a column and code all rows with matching value in another column

[lazypony]

Hi,

I have eye tracking data with 1 row per eye movement with multiple eye movements in each trial. I need to exclude some trials with eye movements that do not meet a set criteria.

I have a column of 0 and 1 for eye movements that fail to meet the criteria. I now need to code 1 for all the rows that come from those same trials in order to exclude the trials.

It sounds straightforward but I have tried lookup and match functions but am not proficient enough in excel to work it out.

I have attached a small example file here.

Any help would be very much appreciated.

Thanks!