hierarchy

Hi all, Someone may have done this before or had some ideas on how to do it so thought I'd check before I dedicated time to it... I have data in a tree and needed to convert it to a '.' separated hierarchy as below. <colgroup><col width="70" span="4" style="width:53pt"> </colgroup><tbody>...

Hi, I am working with a old macro written by someone no longer around (and secondly its not working consistently) I have a reporting Hierarchy that looks like this <tbody> 18615 ,38630,29199,22163,26079,14516,16114,10614 </tbody> I removed the commas and have each ID in its own cell...

Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...

Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...

Hi all, I have a simplified version of a sheet I'm working with below showing the data as it is, and how I'd like it to be.... CURRENTLY... <tbody> Employee Blank Values in Hierarchy Line 1 Manager Line 2 Manager Line 3 Manager Line 4 Manager Employee 1 2 Manager B Manager A...

Hi I am trying to find a way to automatically outline a hierarchy in Excel (group rows) I cannot find a code to do that either For example: <tbody> Code Item Rollup 1 A Title 1.1 B Subtitle Level 1 1.1.1 C Compare 1.2 D Subtitle Level 1 1.2.1 E Subtitle Level 2 1.2.1.1 F Compare...

Greetings, new to the forum. I have a flat .csv file that represents a document with sections and sub sections that will be imported into a requirements management application. This application understands hierarchy, and will recreate it if I can provide a mapping of parent and children rows...

Hi all Using pivottables from olap data sources I often use slicers for filters since end users find it easier. This works great on non-hierarchied dimensions so if for instance I select region-country=canada, then my region-city slicer will only display canadian cities to choose from (due to...

Hello everyone I THINK pivot tables are my answer....but I don't know how to make them work in the way I want :confused: . I am using Excel 2013 on Windows 8.1 I have a database of raw information and essentially I want to be able to produce a Org Structure in a table on a new sheet: - far...

Hi all, New to the forum, so please forgive any newbie mistakes. I have a list of 40,000 unique part numbers, and a seperate database of 500,000 part numbers. The database has many duplicate part numbers, split by Plant (Ownership). The Part/Plant combination on each row is unique, and other...

Hello guys, I have a table that contains how much a client paid for an invoyce ([Valor NF]) and which department received that money. However, my company divides a department in 3 hieararchical levels, which are then represented in the workbook by 3 fields named Dept. Lvl. 1, 2 & 3. Here is my...

I am brand new to the forum and am no expert at excel. I have a MAC Excel 2011 program to work with. I have created a direct selling model that pays commissions based on percentages of sales. I also have partner companies I am working with plus the product distributor. The partner companies (2)...

Hi, I have a workbook that has 6 columns named office, account, exchange, product, and then commision values. Each row is a different commission scheme with not all fields filled out for each scheme; there is a hierarchy. IE lets say the scheme is set at the office level with commision levels...

I have a large flat hierarchy table. I am looking for a method to select a parent and return a list of my lowest level children. I am somewhat familiar with VBA but I don't know where to begin coding this. Thanks so much for any help I am able to receive on this. This has been a great learning...

Hello, I am trying to write a formula that isn't a gigantic IF statement to calculate whether a person has upgraded their type of house or not within a time period. The below are the names of the types of housing. I have two of these lists, the first is from the beginning of the time period...

Hello Everyone I have a list of employees and their managers in excel on Sheet1 (A2 through A? is the employee and B2 through B? is their manager). This goes (so far) up to 8 levels deep. I then have a data validation list that sources column A on sheet1 (The list of employees) that is located...

Hello, I have a table with 1.3+ million records. The table houses account numbers (they can exist more than once), a Field_Data_ID field (is incremental and does not repeat...greatest number is most recent addition), a Description field, START_DT and END_DT both in YYYYMMDD format. My...

The below formula was provided by PGC, and works great: =INDEX($E$15:$E$18,MAX(IF($A$2:$A$8=A15,MATCH($E$2:$E$8,$E$15:$E$18,0)))) In post: http://www.mrexcel.com/forum/showthread.php?t=573346 Now, I would like to add the ability to perform this same action/concept, but using two...

I currently have two columns of ids, employee and supervisor, and need to find what division the employee rolls up to based upon the division's Vice President. I initially have the VP ID and Division in two columns on the same sheet. If the initial supervisor is not found on the VP "table", then...

Hi - would appreciate help with this one. I want to use a standard Excel function to solve a lookup based on criteria problem... I have a 'key' on worksheet(1) with (let's say) 2 columns A & B - example values as follows (approx 75 in total). GIAA 50% GIAB 100% GYEFF 80% etc...