Excel - Removing duplicates in lists (perhaps comparing?)
Posted on 2012-09-07
I have 2 lists of students from 2 dates. List 1 contains students enrolled on 2nd September. List 2 has list of students enrolled on 6th September.
I have inputted the students from List 1 into our own departmental database, and need to enter the people enrolled in the days after 2nd September from the 6th September list (List 2).
I have messed about with duplicates and filters, but cannot quite find what i need to solve this puzzle!
Is there a straightforward way to highlight the differences between the 2 lists as list 2 contains list 1 plus new enrollees?
Thanks for your help in advance