+ Reply to Thread
Results 1 to 3 of 3

Create continuous list of pending task -by referring master list of task completion status

  1. #1
    Registered User
    Join Date
    05-19-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Create continuous list of pending task -by referring master list of task completion status

    Dear Experts,

    I have one sheet with list of tasks, and its work completed percentage, in another sheet, i want a auto populate all tasks for which the work completed % is less than 50 (used as a number and not percentage value).

    I am able to do this which simple if condition, but i am getting some blank rows, which i want to avoid so that a continuous list of all tasks which are <50 can be created.

    Attached is the sample sheet.Pending Task List.xls

    Thank you for assistance.
    ghdreamz

  2. #2
    Registered User
    Join Date
    03-27-2009
    Location
    Surat,India
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Create continuous list of pending task -by referring master list of task completion st

    Do it Pivot Table and Group pivot column.
    PFA

    Regards,
    Vishnu
    Attached Files Attached Files

  3. #3
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Create continuous list of pending task -by referring master list of task completion st

    Have a look at the attached,
    Attached Files Attached Files
    Remember you are unique, like everyone else

+ 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: 3
    Last Post: 06-24-2012, 02:01 AM
  2. Create Gantt Chart from Task List
    By mycon73 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-06-2011, 04:34 PM
  3. [SOLVED] create and expand/collapse todo list under a task in excel
    By flamingo1 in forum Excel General
    Replies: 2
    Last Post: 07-12-2006, 12:05 PM
  4. [SOLVED] how do i create a completion of task checklist
    By chris in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-27-2006, 02:10 PM
  5. [SOLVED] I need to create a job task list that tracks for a 30 day period.
    By Job Task tracker in forum Excel General
    Replies: 1
    Last Post: 12-30-2005, 10:10 PM

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