The table contains:
unique student id
I need to create family ids where 1 or more students live at the same address (streetaddress
) and have the same motheremail
For example, there are 3 students with the same last name living at 111 Main Street.
Once I identify them, I need to assign them a familyid
such as 145-1
There are also 3 students who do not have the same last name but live at 121 Spruce Street. I still need to assign them a familyid
such as 145-2.
is not in the table, but I could add it as a column, if need be.
I added some sample data in the spreadsheet.
Thank you for your help!