Trying to get the name of the highest company name in the hierarchy when a certain condition is fulfilled

[#1]

Hi,

I'm trying to fill the company names in the lower hierarchies from where the first criteria LineNum = 1.

So if LineNum = 1 on Company D then the NewCompanyName should be D,

If LineNum = 0 on Company H then the NewCompanyName should be a company for each existing company on every level meaning rows for  A,B,D,H

Basically I want to check if LineNume = 1 then grab the the CompanyName for that row and use it, otherwise use the CompanyName as is.

Sorry about the bad explanation

The example is just a test I started with.

[#2]

Any ideas?

Thx.

[matt_crowther]

What you require sounds possible but I'm a little unsure as to exactly what you're after - could you post an .xls of how you'd like the final table to look?

Matt - Visual Analytics Ltd

[#4]

Hi Matt,

I've uploaded an example of the final table. Still haven't solved it so if you have any ideas I'd appreciate it