I have an excel spreadsheet that has a large list of member names in alphabetical order, last name sorted. This works well, but I have a lot of people with the same last names because their whole family may attend( Cousins, parents, grandparents, uncles etc...) I need to group the people into their immediate families, within my list. Is there an easy way to do this in excel? Or am I going to have to move these names around manualy?

Thanks!

Suggest you have surnames in one column, first names in another (if not already done) and a new column in which to give members within the same families a unique code. Can then sort into family groups.

Best I can do sorry.