I have been given and excel spreadsheet that has combined 2 data bases.
One data base was a list of all students
One data base was a list of all "on" campus students
I want my final list to equal just students who live "Off" campus
The columns are set up as follows:
A = First Name
B = Last Name
C, D, E, F = Address, City, State, Zip....etc (not important)
So.... after doing a sort by A, then B, the only duplicates will be the students that live on campus. Therefore, deleting ALL duplicate entries will leave me with a list of all Off campus students.
Because we have a lot of duplicate last names, but different first names.
Example:
Column A Column B
Row LastName FirstName
1 Adams Becky
2 Adams Becky
3 Adams Joe
4 Adams Linda
5 Adams Melissa
6 Adams Melissa
Is there a macro to find duplicate Last and First name, then delete them both completely?
ie: I need rows 1, 2, 5, 6 deleted - Leaving Joe and Linda Adams
Thank you
Catherine
One data base was a list of all students
One data base was a list of all "on" campus students
I want my final list to equal just students who live "Off" campus
The columns are set up as follows:
A = First Name
B = Last Name
C, D, E, F = Address, City, State, Zip....etc (not important)
So.... after doing a sort by A, then B, the only duplicates will be the students that live on campus. Therefore, deleting ALL duplicate entries will leave me with a list of all Off campus students.
Because we have a lot of duplicate last names, but different first names.
Example:
Column A Column B
Row LastName FirstName
1 Adams Becky
2 Adams Becky
3 Adams Joe
4 Adams Linda
5 Adams Melissa
6 Adams Melissa
Is there a macro to find duplicate Last and First name, then delete them both completely?
ie: I need rows 1, 2, 5, 6 deleted - Leaving Joe and Linda Adams
Thank you
Catherine