Results 1 to 2 of 2

Duplicate tasks in a project tracker - formula and data consistency help

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2010
    Location
    Birmingham, UK
    MS-Off Ver
    Excel 2007
    Posts
    14

    Question Duplicate tasks in a project tracker - formula and data consistency help

    Hey Team!

    Hope you are keeping well.

    I am hoping you can help me a formula in a Project Tracker i have created.

    I have 4 platforms - A to D and each platform has tasks assigned to it which need to be completed in order based on the sequence in column A.

    Some of the tasks are duplicated across 3 or 4 of the platforms. So for example:

    Task 1 is duplicated across platforms A, B and D. I want to be able to update the Task 1 status to "completed" in platform A and for this to then to feed through to the task 1 in platforms B & D.

    At present, i have just linked all of the duplicated tasks to the relevant platforms, however in my real world project tracker, i will have c5,000 lines of tasks to track and need way of ensuring that all duplicates feed through from their source to the other platforms and also i need a check to ensure that the data across duplicates is correct and consistent.

    In terms of formula consistency checks as i'm going to working with such large amounts of data, i was just going to sort all of the data by duplicate in column D and 'eyeball the data to ensure that it looked consistent but when to this check, my linked formulas change cells, therefore i need a formula that's durable enough to allow it to be manipulated to be 'sorted' in a different sequence to that in column A. Once i have done my consistency checks, i will once again for the data back in sequence (column A).

    I've enclosed a spreadsheet of what i'm trying to achieve with Column F showing the desired outcome. Columns G and H are further comments i've added to detail where data comes from.


    Thanks for your help
    Attached Files Attached Files
    Last edited by mr_vic; 08-03-2020 at 11:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bar Chart with all Project Tasks color coded in a single bar
    By NiCKz_01 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 10-14-2019, 05:22 PM
  2. Project tracker automation
    By hassanm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2017, 05:39 PM
  3. Creating a project tracker
    By sorensjp in forum Excel General
    Replies: 8
    Last Post: 01-17-2017, 05:45 AM
  4. [SOLVED] Project supplies tracker
    By makinmomb in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-12-2014, 12:55 PM
  5. Replies: 0
    Last Post: 06-14-2012, 02:49 PM
  6. Importing tasks from ms project
    By adas12adas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2009, 08:21 AM
  7. How can I move Project tasks into an Excel outline?
    By Russell Daum in forum Excel General
    Replies: 0
    Last Post: 06-24-2005, 12:05 PM

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