+ 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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,533

    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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    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.

+ 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