Deleting entire rows using conditions related to column A and B

[ztheb721]

I have a list of 55K rows and 20 columns. The list consists of names, dates, other identifying info. I've attached a workbook showing a small hypothetical example.

The following assumes that you are looking at the workbook.

For this example I want to keep only one row per person. The row that will be chosen for an individual person will be based on the date of service variable. I need to only keep the row with the most recent date of service and delete all the rest of the rows for that individual.


I provided an example of what I would like the table to turn into.


Potential Solution I've thought about (just don't know how to write the code):

Step 1. Turn the dates into numbers

Step 2. Write a VBA code that searches for name ID matches within column "A" then for every match it searches the adjacent cell in column "B". If the value of the cell in column "B" is the highest out of all other matches, delete all other rows with the individuals name ID and leave just the most recent.

[MrGes]

Hi,
try this:

Please Login or Register  to view this content.