troubleshooting Question

Working with Asset Hierarchy in Table in Excel

Avatar of gh_user
gh_userFlag for Australia asked on
* AssetMicrosoft ExcelMicrosoft Office
2 Comments1 Solution199 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Ejgil Hedegaard

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros