Results 1 to 7 of 7

Grouping staff hierarchy in xls

Threaded View

  1. 09-17-2013, 03:18 PM #1
    PdK77
    PdK77 is offline
    Registered User
    Join Date
    09-17-2013
    Location
    Eindhoven, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Grouping staff hierarchy in xls

    Hi,

    I have an xls file with ~120000 records. Each record shows the name of an employee and their manager. It also shows the "Tier" within the organisation. I would like to create a formula that allows me to count all the reports that sum up in a hierarchical tree of a "Tier-1" manager.
    I attached an example file.

    Hope you can help me out!

    Rgds,
    Peter
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  2. Grouping rows as hierarchy in vba
    By Jaymerry in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-30-2011, 04:26 AM
  3. Staff Hierarchy Problem
    By ot070707 in forum Excel General
    Replies: 2
    Last Post: 10-21-2011, 01:38 AM
  4. Grouping cells as hierarchy
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2009, 02:38 AM
  5. How to produce Grouping based on hierarchy list?
    By masai_chadi in forum Excel General
    Replies: 10
    Last Post: 10-06-2006, 10:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1