Working with Asset Hierarchy in Table in Excel

gh_user
gh_user used Ask the Experts™
on
Hi
I need help to develop an Excel table to work with data on assets that are in a hierarchy.
For each data row there is an asset number. This shows the relationship between the assets.  It can either be a parent of an asset or a child of a parent asset.
If it is a 'parent', I would need to have the following:
- the word 'parent' shown in  column B, the row 'greyed out', and the calculation in column G showing no value
If it is a 'child', I would need to have the following:
- the word 'child' shown in  column B,

I would also like to show in column A the level of the asset in the hierarchy.

The attached spreadsheet shows on one tab draft table with raw data, and the other tab the appearance I am trying to achieve as described above.

Can someone suggest how to do this and also demonstrate using the draft table with raw data.

Thanks
Table-Example.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Hi Ejgil.
Thats great.  Thankyou very much!!!!!!!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial