Results 1 to 5 of 5

Team list

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    England
    MS-Off Ver
    2010
    Posts
    43

    Team list

    Hi all, Happy New Year.

    I am trying to create a formula that pulls together a list of project team members based on the number of hours they have allocated towards a specific project. This list needs to be based on the Project name I enter into a specific cell. For instance...

    project matrix.png

    ... in the above example, if I enter "Project 2" in cell B11, I was hoping to see Resource D, E and F from row 15 onwards under "Resources on Project". I'm guessing the condition would be IF "Cell" is greater than 0, return the name of that person

    Was playing around with Index Match but can't work out how to create a list. Any help with this will be great.
    (I have attached my workbook if this helps).

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-06-2012, 06:02 PM
  2. [SOLVED] sort list of players by team from player list on separate sheet
    By Biff in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 PM
  3. sort list of players by team from player list on separate sheet
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  4. Replies: 2
    Last Post: 09-06-2005, 06:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1