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.
Bookmarks