Hi all,
I am downloading lists of pupils in school on a weekly basis and updating a separate spreadsheet. The lists never match as there is so much movement in and out of school. Short of actually checking 845 rows side by side. is there a clever way of checking the two lists of names and then resolving mismatches?! Thanks in anticipation.