http://oi48.tinypic.com/9rovuc.jpg
1.see the image.
Let's see there are hundreds of different families like that in another sheet.
how to group those by family members?
EX: all FATHER,MOTHER goes to a one group.
all FATHER,MOTHER,SON goes to another group. like that.
first, all the mother,father families are grouped together.
then all the FATHER,MOTHER,FAMILIES are grouped. like that......
is it possible?
It is possible but not complete if you have another reference column... Let's say last name. Sort the last name column first, and sort the relationship column second (in the sorting list). The incomplete part is that the daughter who married another family may have her last name changed. That means, she will appears under the husband family, not hers.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
