troubleshooting Question
Working with Asset Hierarchy in Table in Excel
asked 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
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
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.