Help with deriving information from multiple cells

[abjeffre]

Hello everyone, I just need some help with generating some information.

I have a data set that has three columns A. child B. mother, C. father. Each person is represented by a numerical value. I need to get a listing of all the siblings pairs from this data. Basically i need a list of all of the all the pairings in column 1 that have the same value in column 2 and 3. Note, that I would like to exclude relationships when there is a 0 present in either column B or C. Does anyone have any ideas?

I have attached a link to the spreadsheet. I hope someone can help.

https://docs.google.com/spreadsheet/...EE&output=html

[shg]

Welcome to the forum.

Sorting descending by Mother and Father will group siblings:

Please Login or Register  to view this content.

[abjeffre]

Thanks for the info and the welcome!

After I sort it in descending order Is there an easy way to retrieve sibling pairings so I will wind up with 2 columns of all of the sibling relationships.

ie.


80 183
183 312
312 80
218 323
218 338
218 342
323 338
323 342

I have got 32 of these data sets and it would just kill me to go through it all by hand.