+ Reply to Thread
Results 1 to 2 of 2

Extract all data after multiple specific dates

  1. #1
    Registered User
    Join Date
    12-16-2019
    Location
    NY, US
    MS-Off Ver
    2019
    Posts
    1

    Extract all data after multiple specific dates

    I hope someone can help me on this. I have two sets of data as follows:

    Data Set 1:
    Name Date Hours
    A 10/20/2019 2
    A 10/21/2019 3
    A 10/22/2019 4
    A 10/23/2019 2
    B 10/20/2019 1
    B 10/21/2019 2
    B 10/22/2019 7
    C 10/20/2019 2
    C 10/21/2019 4
    C 10/24/2019 8
    C 10/25/2019 6
    C 10/27/2019 5
    D 10/23/2019 4
    D 10/24/2019 1
    D 10/25/2019 8
    D 10/26/2019 2

    Data Set 2
    Name Date Hours
    A 10/22/2019 4
    B 10/21/2019 2
    C 10/25/2019 6
    D 10/24/2019 1

    So the requirement is that we want to extract all the data from Data Set 1 from the dates mentioned in Data Set 2 for each Name. For example, in the data set 1, there are 4 records for the Name A, so after the extraction, the output should be:

    Name Date Hours
    A 10/22/2019 4
    A 10/23/2019 2

    and same for the other Names in the Data Set 1:
    B 10/21/2019 2
    B 10/22/2019 7
    C 10/25/2019 6
    D 10/24/2019 1
    D 10/25/2019 8
    D 10/26/2019 2

    I appreciate your help here Thanks in advance.

    Edit: I have attached Excel file with the data in it for your convenience.
    Attached Files Attached Files
    Last edited by rockyone; 12-17-2019 at 09:38 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,919

    Re: Extract all data after multiple specific dates

    Welcome to the forum.

    See the yellow banner at the top of the page to see instructions on how to attach a sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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. Need to extract specific data from a workbook with multiple worksheets
    By bremar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2018, 01:23 AM
  2. [SOLVED] extract data with multiple headers and dates in colA
    By roothog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2015, 07:08 AM
  3. [SOLVED] How to extract specific data only and create multiple sheets
    By pahari75 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-06-2014, 11:06 PM
  4. Extract Specific Data from Multiple Workbooks
    By beartimeusa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2013, 08:54 AM
  5. Extract a Specific data from multiple webpages to excel
    By pari9485 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2013, 01:10 PM
  6. Extract specific column data from specific sheet from multiple files in a folder
    By piggyfox in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2013, 11:51 AM
  7. Macro to extract data from multiple workbooks, specific sheet, specific cells
    By crissandraauree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 03:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1