hierachy

  1. 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...
  2. 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...
  3. 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)...
  4. 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...
  5. 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...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top