Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parent/Child Field
This should be a pretty basic question.
I need to fill in the child field with the parent field of a WBS structure. Let me give an example V/XXX3.CHA.07 4 V/XXX3.CHA.07.02 V/XXX3.CHA.07.02 5 V/XXX3.CHA.07.02.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.03 V/XXX3.CHA.07.03 5 V/XXX3.CHA.07.03.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.04 5 V/XXX3.CHA.07.04.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.05 5 V/XXX3.CHA.07.05.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.06 5 V/XXX3.CHA.07.06.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.07 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parent/Child Field
On Sep 4, 8:15 am, turtle wrote:
This should be a pretty basic question. I need to fill in the child field with the parent field of a WBS structure. Let me give an example Parent ID Lev V/XXX3.CHA.07 4 V/XXX3.CHA.07.02 V/XXX3.CHA.07.02 5 V/XXX3.CHA.07.02.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.03 V/XXX3.CHA.07.03 5 V/XXX3.CHA.07.03.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.04 5 V/XXX3.CHA.07.04.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.05 5 V/XXX3.CHA.07.05.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.06 5 V/XXX3.CHA.07.06.01 V/XXX3.CHA.07 4 V/XXX3.CHA.07.07 Sorry, i didn't finish my explanation. In the first column where there are blanks i want it to look at the 3rd column to get the parent id. If the level is 5 and the 1st field is bland then i want it to look for the last 4 and put in that parent. I suck at explaining things obviously so if you have questions let me know. thanks, KO |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
parent/child relationship between rows? | Excel Worksheet Functions | |||
Creating child worksheet from parent | Excel Worksheet Functions | |||
parent/child ranges | Excel Programming | |||
finding multiple parent-child relationships? | Excel Worksheet Functions | |||
Sorting Parent Child | Excel Worksheet Functions |