+ Reply to Thread
Results 1 to 5 of 5

List down Task from a table

  1. #1
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Wink List down Task from a table

    Hi,
    I need to list down the task for a particular person (Listed in table) which I will be selecting from the dropdown in the table highlighted in Blue. How to do that?.


    Excel-Help.xlsx
    And is it possible to display only the non blanks cells in the validation list in N4, ?
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: List down Task from a table

    This gets you most of what you want. The bottom of the table has an array formula to give the drop down list without blanks. It's got an extra row there which isn't the tidiest - maybe somebody else here could tidy that up. It does mean that I could set up a dynamic named range for the data validation list.

    As for the original problem I used an offset function matching the name from the drop down list to the titles at the top of the table to get the right column.
    Excel-Help.xlsx

  3. #3
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: List down Task from a table

    WOW... this works perfectly except for one thing.

    For Mr.C, the task is coming nice. But for Mr.D2, the task lists are filled by '0' where there should be blank... What may be the reason?

  4. #4
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: List down Task from a table

    Put this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in L9 and drag down.

  5. #5
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: List down Task from a table

    Thats nice...
    Working perfectly now.. thanks

+ Reply to Thread

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: 04-15-2014, 03:23 AM
  2. Help me clean up my task list
    By eljusticiero67 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2012, 12:45 AM
  3. Replies: 3
    Last Post: 06-24-2012, 02:01 AM
  4. Task list
    By kumaramitoujjain in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2010, 12:02 AM
  5. Task List
    By j.vaughan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2008, 07:23 AM

Tags for this Thread

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