Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Family tree
I am working on office xp excel spread sheet containg data in two
columns.what function will count row numbers depend on other row numbers. 1 NAME CODE 2 JOHN 3/S 3 ROHIT 7/S 4 RUBY 2/D 5 MONIVA 6/D 6 CATHERINE 7/D 7 JIMMY 0/S 8 LOPAZ 5/S IN THIS EXAMPLE JOHN IS SON OF ROW 3 PERSON,WHO IS SON OF ROW 7 PERSON.LIKEWISE MONIVA IS DAUGHTER OF CATHERINE ,WHO IS DAUGHTER OF ROW 7 PERSON 'JIMMY'.JIMMY'S CONTRIBUTION TO FAMILY DYNASTY IS 6.MONIVA'S CONTRIBUTION IS 1.LOPAZ'S CONTRIBUTION IS 0.HOW I CAN COUNT A ROW PERSON'S CONTRIBUTION TO FAMILY DYNASTY AND DISPLAY THEIR NAMES |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone tree template | Charts and Charting in Excel | |||
making a decision tree using excel! | Excel Discussion (Misc queries) | |||
Logic Tree, MS help = useless | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Tree View for excel sheets | Setting up and Configuration of Excel |