+ Reply to Thread
Results 1 to 3 of 3

check missing dates in range delete in another range

  1. #1
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    check missing dates in range delete in another range

    I have a worksheet table with column of dates (B). An applied filter (for other attributes), outputs some visible rows where sometimes the date range will have a gap(s) in it such as:
    ..............Column A
    Row 358 8/10/18
    Row 399 9/20/18
    Row 400 9/21/18

    I have a separate workbook file with sequential dates in column (A). For example starting at 8/10/18 and ending at 9/22/18 such as:
    8/10/18 06:00
    8/10/18 13:00
    8/10/18 15:00
    8/11/18 01:00
    8/11/18 06:00
    8/11/18 14:00
    ...cont. through to 9/22

    I would like to remove all dates within the second workbook that are not within the first workbook, so everything 8/11 - 9/19 regardless of time would be removed. I don't need to insert rows or re-output the date, just delete dates that are not within the first workbook. What would be the most efficient way to find the missing dates and deleting all matches within a separate workbook without having to loop. There are thousands of rows at times, so I would like to avoid looping if at all possible.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: check missing dates in range delete in another range

    Please provide sample file as per yellow banner above. Do you want to clear the contents of the cell or delete and shift the cell? Not sure I can avoid looping.

  3. #3
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    Re: check missing dates in range delete in another range

    Thanks for the reply but I was able to code this using a few loops and Finds that process it fast enough. The solved thread wasn't available for a bit, so I couldn't mark it.

+ 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. Check if range of dates fall between two dates
    By Wasilsky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2017, 08:40 AM
  2. [SOLVED] Advanced SUMIF - date range including missing dates
    By chococ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2015, 02:12 PM
  3. [SOLVED] Check range from one sheet against range in another sheet and then delete row if exists
    By zigojacko in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2013, 12:37 PM
  4. Replies: 4
    Last Post: 10-19-2013, 07:50 AM
  5. Check dates in range either same dates or different dates by formula
    By breadwinner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2013, 07:42 AM
  6. check if dates fall within a range
    By mcinnes01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2011, 01:15 PM
  7. Check Range; if equal to X, Y, or Z then keep else delete
    By kmjones in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-02-2009, 12:34 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