Direct & Indirect Reports

Discussion in 'Excel Programming' started by lg123, Mar 28, 2014.

  1. lg123

    lg123 Guest

    Hi All - I'm looking to have a simple output file created that will sho
    me how many direct reports and how many indirect reports every perso
    would have in a given data set (including a zero for those that do no
    have either)...

    - I have the below data fields to work with:

    Person Name; Person ID; Supervisor Name; Supervisor ID

    - I would ideally like two output tabs where one gives a summary:

    Person Name; Person ID; Count of Direct Reports; Count o
    Indirect Reports

    And where the second gives the detail:

    Supervisor A:
    Direct Report A____ Indirect Report D
    Direct Report B____ Indirect Report E
    Direct Report C____ Indirect Report F

    Count for both direct and indirect

    ___________________________________________________________
    Supervisor B:
    Direct Report H____ Indirect Report K
    Direct Report I____ Indirect Report L
    Direct Report J____ Indirect Report M

    Count for both direct and indirect

    ___________________________________________________________

    Any thoughts would be extremely helpful and appreciate


    --
    lg123
     
    lg123, Mar 28, 2014
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.