Closed Thread
Results 1 to 4 of 4

Splitting Multiple Days From a Data Set?

  1. #1
    Registered User
    Join Date
    06-09-2020
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    5

    Splitting Multiple Days From a Data Set?

    So here is my problem... I have a very large and very basic data set which includes 4 columns of data (production line #, order #, date started, date finished). I'm trying to manipulate the data to compare when certain pairs of production lines are running at the same time. A lot of the orders only run for a part of a day and for those I could just use the starting date for comparison. If I just use the starting date for the other orders though, I will miss the days when a line ran for more than one day on a particular order. Is there a way or formula that anyone knows to add lines of data for the other days of these multi-day orders so I can accurately compare the data by date? I basically just want to know whether a particular line ran during a particular day of the year, but how do I get that from the data set I have to work with? If anyone has any thoughts or guidance, I'd greatly appreciate it.

    Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,485

    Re: Splitting Multiple Days From a Data Set?

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    06-09-2020
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Splitting Multiple Days From a Data Set?

    Here is a small sample

    In this instance Line 9 shows an order that was run from 3/31 until 4/2. By just using a start date, I lose the information that line L10 also ran on 4/1. How do I get this to count as a "run day".
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,485

    Re: Splitting Multiple Days From a Data Set?

    As you have chosen to post in the Commercial Services section, this thread is now closed.

    https://www.excelforum.com/commercia...-data-set.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cutting Data to the Latest 365 days for multiple sets of data
    By improvemyknowledge in forum Excel General
    Replies: 5
    Last Post: 09-12-2018, 10:00 PM
  2. [SOLVED] average time value between data in column for multiple days
    By bolo11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2017, 04:22 AM
  3. Spliiting 1 row of data into 2 lines based on next unique value
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2016, 02:59 PM
  4. Replies: 15
    Last Post: 06-17-2016, 01:59 AM
  5. [SOLVED] Subtract dates to give a total amount of days - Multiple Data
    By t_man000 in forum Excel General
    Replies: 2
    Last Post: 07-23-2015, 11:14 PM
  6. Spliiting calls equally formula
    By skate1991 in forum Excel General
    Replies: 3
    Last Post: 03-09-2015, 07:50 AM
  7. Replies: 8
    Last Post: 07-02-2014, 01:39 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