+ Reply to Thread
Results 1 to 1 of 1

Data With Date & Time Lag

  1. #1
    Forum Contributor
    Join Date
    10-09-2010
    Location
    London
    MS-Off Ver
    Excel Version Office 365
    Posts
    215

    Data With Date & Time Lag

    Hi

    I have attached a workbook that requires 3 requirements to assist on pulling data.

    1. Formulae & Rule required

    This spreadsheet represent a forecast so if I am forecasting from April - this will be month 1 Feb month 2 etc.

    In example ID 131, there is data from Mar. So CELL S1 would show 1 to end month 9. I need a formulae to pick column S and T

    In example ID 547, data starts from June so the start date is 3 for June and end month 9 for Dec.

    2. Another rule:

    If there is a number greater than zero in column H, and I put a number for example 1 in column R, it would start 1 month later, so in this case for ID 131 it would be month 2


    3. Lastly
    I need a formulae to then pull the data of column S as start month e.g. Cell S3 MI Reports into Cell E6 phasing tabs
    Attached Files Attached Files

+ 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: 9
    Last Post: 02-15-2015, 07:32 PM
  2. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  3. Replies: 2
    Last Post: 08-12-2013, 02:38 PM
  4. [SOLVED] How do I convert imported date/time data to date/time format?
    By andykent99 in forum Excel General
    Replies: 4
    Last Post: 01-03-2013, 07:47 AM
  5. Display the date and time each time the data in a cell range is changed
    By BVZM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2012, 01:23 PM
  6. [SOLVED] Subtract date/time from data/time and get difference in minutes
    By zit1343 in forum Excel General
    Replies: 2
    Last Post: 06-18-2012, 11:23 AM
  7. Removing time from date/time data - Excel 2010
    By Huzzah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2011, 12:03 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