Results 1 to 2 of 2

Extract all data after multiple specific dates

Threaded View

  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.

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