Alter code to only delete data from Column A

[ge0rge]

I have hundreds of dates in Column A. They go with the data in column B. I want to delete all duplicate dates except the top one of each set but not all the rows. Here is an example with Column A and Column B.

1/2/09 M1928
1/2/09 M1767
1/3/09 M2765
1/4/09 M8878
1/4/09 M8827
1/4/09 M1234
1/5/09 M1556

to look like this:

1/2/09 M1928
Blank M1767
1/3/09 M2765
1/4/09 M8878
Blank M8827
Blank M1234
1/5/09 M1556

(I had to use blank in place of a blank to make it appear correctly.)

Here is the code I have been trying to alter:

Please Login or Register  to view this content.

Thanks.

[StephenR]

Like so?

Please Login or Register  to view this content.

[foxguy]

Cycling through all the cells can be slow. It's a lot faster if you copy the data into an array, process the array, then copy back into the spreadsheet.

Please Login or Register  to view this content.