hierarchical

Hi there, I am trying to find a way to harmonise the way a product is coded from various ways people may have entered it (i.e., the cut of fish - in parentheses here but note that this is not always the case). For example, in the sample data below, "Gutted" and "whole gutted" mean the same...

Hello, I need help! I need to create a formula that will help me validate data within a hierarchy rollup. As an example, I created a spreadsheet of cities with the State, Country, and Continent they map to. I'm looking to create a formula that returns a count if the state maps into more than...

Hi, I am trying to establish below in hierarchical format. Is there anyway if we can achieve output as below. tried grouping but didn't work. Input <colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody> Node Level A100 1 101 Child 1 2...

Hi, I have hierarchical data in a named range "Table1" that looks like below, where the "Count" is the value for each Category, and The "Cumulative Count" is the sum of the current level and all child levels. Is there a way to quickly get this into a format to use the Treemap or Sunburst plots...

Hi! I want to make sunburst chart for my company showing, an annual cycle. The cycle will show month, week, day and what action to take. I have made an excel sheet wich contains my data, see enclosed picture. <tbody> Month Week Weekday Activity Januar Uke 1 Man Vareopptelling Tir...

Hi, I have been creating folders in Outlook using a simple macro that creates folders from the first column of an Excel sheet under the folder currently selected. That macro is based in Outlook. We are at the beginning of a new fiscal year and I would really like to create the whole tree at...

Okay so I have quite the conundrum. I'm pulling hierarchical data out of a data system. I'm utilizing Monarch 11 in order to strip out the necessary data that i need. An example of what I'm left with is below. <tbody> PROFILE NAME Option1 Option2 Option3 Option4 Option5 BASIC ACE ACE SCE...

Hey guys, I have been working on a project in Excel for weeks with no luck. What I am trying to make is an interactive BoM (bill of materials) setup almost like a Family Tree with buttons to add new child items. I've been working on coding this for weeks with no luck. Here is a link to my...

Have an interesting problem. I suspect that this may need to be resolved with code but if there is a nifty array formula that would be even better. Here's a sample set of data A B C Mgr Emp Y/N M1 A1 Y M1 A2 Y M2 A3 N M3 A4 Y M5 A5 N M1 Y M3 M2 Y M7 M3 Y M2 M4 Y M3 A6 Y M2 A7 Y M5...

Can someone help me to arrange the columns given below: Note: The tree can expand as gievn in exampe and can have more values. TOP of the tree being '1' :INPUT========================================COLUMN1 COLUMN2---------------------------------------1 = TOP1-2001 = MIDDLE1-2001-2002 =...