I have recorded answers from same participants to two questionnaires. The questionnaires are the exact same questions except one was administered before training and one after to establish any change in opinion. The before results are sheet1 and the after are sheet2. The rows in each sheet represent the answers from one participant i.e. row1 on sheet1 and 2 is the same participant.

What i am looking for is a way to identify which participants completed both questionnaires and which completed one or the other.

I also have a column with notes so if they were absent for one this information is available. Would it be possible to show the notes next to the counts?

I hope this is clear and thank you for any help in advance.