hierachy

  1. T

    Formula to validate for incorrect Hierarchy rollup

    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...
  2. P

    Power Pivot: Trial Balance to P&L Geography with two criteria

    Hello - I’m trying to make a P&L statement from a trial balance in PowerPivot vs. the historical lookup method. In a simple example, this was easy to do in PowerPivot, but now that I’m trying to add in a pairing that needs to occur I cannot create the relationships. In my simple example I have...
  3. G

    SmartArt Hierachy - Multiple "Titles" Possible?

    I've been building up an organizational chart for where I work using the Excel SmartArt. Currently I'm using the Name and Title template. I was wondering if it is possible to somehow add additional titles to all the boxes. Below is a quick example similar to what I currently have built up. I'm...
  4. J

    Sorting part numbers (creating a BOM)

    Hi All, I have a list of values that gets automatically exported into excel but i need to change the layout of the numbers so that they are useful in other excel sheets. Currently it gets exported into 3 columns (LHS of picture) but it need it in 2 columns (RHS of picture)...
  5. I

    Comparing Hierarchies

    Hi, I'm pretty new to Excel, and I'm still not 100% around the functions, so any help, that someone could give me on my question would be much appreciated! I have 2 sheets with similar hierarchies of 5 levels in the following format: Sheet1 Row L1 L2 L3 L4 L5 1 a b c d e 2...
  6. G

    Can someone Check My Code, it works but...

    I'm trying to produce a folder hierachy in Excel showing all Folders & Files, in exactly the same order Windows Explorer would. My Code brings the Folders & Files back, but not in the exact order (it puts the files in a root folder first, rather than at the bottom of the list) and I also want to...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top