parent

Hi experts! I'm trying to traverse and convert a Parent|Child file into a separate hierarchy, with a header. The 'depth' of the Parent|Child relationships is yet unknown, so the output could stretch to many columns on the right. I have tried coding for just two input columns, with little...

Hi all I have a 2 workbooks set up s parent and chid - and a formula to pull values into the parent from the child: =VLOOKUP($A2,'https://tsbcloud.sharepoint.com/sites/ChangeTestingTeam/UAT Testing Collateral/1. Releases Collateral/Release 17/14. Preparation and Execution Tracker/[Outside of...

I have a worksheet with columns A through R. I need to sort this worksheet by the value that is in Column C. I have searched for the answer and have tried several suggestions, but the worksheet never sorts. In my code below I have commented out all the things I have tried. Is what I am trying to...

Hi all, Here is the code to create a structure chart from range A to range C of the sheet ‘’BD’’ Here is a screenshot of the sheet ‘’BD’’ https://www.dropbox.com/s/vyik32v24dp2ysm/sheet%20BD.png?dl=0 There is the ‘’Big father‘’ in A2 which is the ‘’Boss’’ The column B states all the ‘’sub...

So, I have a list exported from a system containing unique employee ids (children). Each of these rows has the employee’s manager unique id (parent). One of the employees is the CEO and is to be considered level = 1 I would like a way to calculate per employee what level they are on in the...

Does anyone have a formula to use the Ultimate Parent Company Id field to pull back data/info on a company (as opposed to using the ISIN number, the ticker, the cusip etc.). Thanks,

Hi, In below example in column A+B, i have hierarchy on the node level of the parent in column A and the child in column B. I would like to derive the text of each parent in column C, like below. Is there a formula for column C how i can derive this value? Column A Column B...

Hello expert Excel users! Below i will describe what is the purpose of my first forum post, so bear with me. So i have multiple tabs defined as tables in a big excel file. Each table has one or more columns but then, some of the tables do have common fields among them. What i want to do is...

Hello, I have a very very big problem with my last Pivot table. I have to calculate difference between Parent total and intermediate value, but not in percentage terms. I need to find difference in numeral. In my table is a leading product code. I have many product codes each of which...

Hi all: I have Folder Parent with child folder: 2019, 2018, 2017. Each folder have child folder too: 201901,201902,201903,201904.....201912 It's look like: <tbody> Parent 2019 201901 201902 201903 201904 . . . . . . . 201912 2018 201801 201802 . . . . . . . . . 201812 2017 201701 201702...

Dear all, I'm trying to find a way to add textbox to shape created by the code below Sub créeShape(parent, niv, Attribut, coul) hauteurshape = 48 largeurshape = 92 colonne = colonne + 1 forga.Shapes.AddShape(msoShapeRectangle, 10, 10, largeurshape, hauteurshape).Name = parent...

Dear all, I try to find a way to rearrange a structure chart Here the current image I get https://www.dropbox.com/s/25sxfbbhv1vb9pj/CUURENT%20DIISPLAY.png?dl=0 Here what I would like https://www.dropbox.com/s/pquidh4eul69mi2/Rearrange%20structure%20chart.png?dl=0 Sheet 1, In the range A2...

Hi, Can anyone help me, as i have data in 2 column and need to create hierarcy. please refer the example below <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> Child Parent A B B C C D D D </tbody> My desired output is as below...

I am looking to create a calculated field in my pivot table using the value generated from the 'percent of parent row'. I'd like to multiply it by another column but am finding that this might not be possible. Is there a way to do this? Or if not, is there an alternative? The pivot table has 4...

I can't seem to sort the excel datasheet in the right way. It needs to be in a particular way so the products can be merged while uploading. In the screenshot, I show you how it is now and how it needs to be. There are around 65k rows, sorting one by one isn't an option. I also provide a sample...

I have a list. The first column is the Parent Part Number, the second is the individual parts that go into each parent. I am trying to see if the individual part is used in more than one parent. What I need is to come up with a percentage. its kind of hard to explain. Hope this helps. The...

I have data from Row one down a couple of hundred rows. Its a list of parts that go into each parent part number The report I grab the data from only puts the parent part number in column B once. So if it puts Parent "ABC123" in column B then it has 300 parts it will not list the next Parent...

I have code that someone on this site graciously provided a long time ago. Below is what I required as is the code MickG provided. I am trying to use this code again, but It doesn’t like the format of the data in column A. If I type over whats in there, the code runs fine. My problem is the...

Hello, I realize this will likely require an excel macro, but I'm not sure how to write this one... I've got the following kind of data in one worksheet: <tbody> SKU PARENT SKU OB1 PR1 OB1 FR3 OB1 X8 OB1 LT IT1 LT OI4 LT LK-4855 OB1 IT-9855 </tbody> I would like to...

Hi Mr Excel :-) I have a table that can change in rows/columns. In this table I only have one data per row. The columns indicate the hierarchy of parent child structure. The parent is on the left. For example : <tbody> Level1 Level2 Level3 A1218 A1219 A1220 A1200 A1110...