I have a list of student numbers in col A
A list of students who attended a lecture in B
how can I find out who is missing .
I tried a if along if b1:b100=a1,"y","n" so I would get a list y and n in the correct order but it looks like if wont accept ranges
Thanks
Mark
Bookmarks