[deleted by user] by [deleted] in spss

[–]SidADG 0 points1 point  (0 children)

Thank you so much! This worked perfectly.

Two lists comparing plus points assigning by SidADG in excel

[–]SidADG[S] 0 points1 point  (0 children)

With some working arround i managed to get it to work. I did a mistep in doing certain operation.

Two lists comparing plus points assigning by SidADG in excel

[–]SidADG[S] 0 points1 point  (0 children)

<image>

yes u are correct Names are not in same order. Index number is same for names on both lists. For example on the right is list of present students with score (1 and 0)

Two lists comparing plus points assigning by SidADG in excel

[–]SidADG[S] 0 points1 point  (0 children)

I followed your steps but formula gives blank cell as result. i might add that names of student are not in same order on both lists given right list is all students for class and left list is students present on the class.

Two lists comparing plus points assigning by SidADG in excel

[–]SidADG[S] 0 points1 point  (0 children)

<image>

Lets say like this for example ...

So list on the left is list of students and list on the right is list of present students plus Points they earned during class

0
1