Select column X

2003 DataFilterAdvanced FilterUniques only.

Copy to another place.

2007 DataRemove Duplicates.

Unselect all. Select only column X and remove.


Gord Dibben MS Excel MVP

On Mon, 7 Jun 2010 13:06:22 -0700, Jbm
wrote:

Hi,
I checked out the archives for close to an hour, but I couldn't figure out
how to change the codes given there to suit my needs.
I have a large set of data, from about A1 to X441. In column X, there are a
lot of exact duplicates, and I need to delete the rows where those duplicates
are (but still leaving the first instance of the duplicate). For example:

John Smith Oxford St.
John Johnson Oxford St.
John Johnson Rubble St.
John Smith Oxford St.

All of those have things in common, but I only want to delete the final row
(and the whole row, not just the cell), because it is an exact duplicate.
How do I code for this? Excel 2007.
Thanks,
Jbm