How to 'group' data in excel and find the maximum in the group
I have parent and child accounts that make a family. If the Parent_acct = Accnt_no then its parent. I need to find the maximum Term in the family and show as Family_term (this is to be calculated) for each account. What's the good way to do it? Sorry cannot post an image yet.

Parent_acct_no   Account_no    Type    Term         Family_term(max)
565              565           Parent  45           78
565              256           Child   78           78
331              331           Parent  23           87
331              754           Child   87           87
331              823           Child   19           87
How to 'group' data in excel and find the maximum in the group
===

I have parent and child accounts that make a family. If the Parent_acct = Accnt_no then its parent. I need to find the maximum Term in the family and show as Family_term (this is to be calculated) for each account. What's the good way to do it? Sorry cannot post an image yet.

Parent_acct_no   Account_no    Type    Term         Family_term(max)
565              565           Parent  45           78
565              256           Child   78           78
331              331           Parent  23           87
331              754           Child   87           87
331              823           Child   19           87