We help IT Professionals succeed at work.
Get Started

Working with Asset Hierarchy in Table in Excel

193 Views
Last Modified: 2017-11-05
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
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE