200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have a master list that I need to generate other lists from. the master list has First Name, Last Name, Grade, Graduation Year, email address, phone, etc. I have duplicate last names belonging to different email addresses. I would like to generate a list that allows me to have a column with oldest child first name and family last name.
Is this at all possible?
Sort by Grade and then remove duplicates.
Select the data > Data tab > Remove Duplicates > uncheck all but the second name field > hit OK.
After that, only the first occurrence for each last name will remain.
The list you want seems to be a full copy of the Master sheet, sorted
All of this is standard Excel issue and can be accomplished with a few clicks.
Then, if you wish to remove all but the oldest child from the list, that would be a VBA operation requiring no more than half a dozen lines of code, if as many.
