Headache (Spreadsheet related)
I have a Spreadsheet, let us call it "Student A". This spreadsheet contains nearly 10,000 rows.
I have another Spreadsheets, "Student B". This spreadsheet contains nearly 2,000 rows.
Due to a balls up by a member of the data analyst team providing us with a report for student logins, we obviously have a lot of logins that will never ever be used as the students go back years! (Imported from "Student A").
Somehow I need to create a "Student C" spreadsheet that contains all rows from "Student A" that do not appear in "Student B" so I can then run "Student C" to remove all the 'dead' logins!
Any ideas? As my brain is breaking the speed limit right now...