Grouping and deleting data based on corresponding date values

We are planning a export some data from an old database to a new one. The old database has a function that was supposed to close a client's case and archive the record if there is no action on it for 180 days and no future contact planned. The problem we have faced is that this "automatic" facility requires you to manually access each clients record for it to apply the auto close and archive. I have exported the data I need from the old database but we have several hundred open case IDs who need to be deleted before we can import the data to a new system.

I am wondering if it is possible to use excel to identify the client IDs with no contact for the previous 180 days and who have no contact planned for the next 180 days and to either highlight or delete all the unneeded rows from the spreadsheet

I have attached an extract of the data set we are working with

Thanks in advance for any assistance

Hi
Thanks JLGWhiz for the speedy reply but running the macro (which works perfectly BTW ), it looks like I have not explained myself properly in the OP.

We are wanting to only identify clients that are classed as live - the definition being that they have had no contact in the past/next 180 days so I was looking at a technique to highlight (or delete) any client IDs and all their associated appointments if they do not fall within that defined parameter

J

Here's a formula based solution.

1. Copy the Client ID's in col-A to an unused column, say, col-D
2. Select col-D then on the ribbon Data > Remove duplicates
3. In E2 and copied down to cover all client IDs
4. Formula:

   Please Login or Register  to view this content.

5. In F2 and copied down to cover all col-A entries:
6. Formula:

   Please Login or Register  to view this content.

7. Any row in which this formula evaluates to "FALSE" can be deleted.

See the attached workbook

Let me know if this works for you.

Glad to hear it! Thanks for the feedback and reputation points.