Delete unwanted rows
 

With your data in A1:A1500, in cell B1 put the following formula and copy down:-

=IF(COUNTIF($A$1:$A$1500,A1)1,"Keep Me","")

Now select all the data and sort on Col B in descending order.

Then just delete all the unwanted records at the bottom.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Gareth" wrote in message
...
I have a sheet of data which is made up of all customer details and updated
ones (all is approx 1,500 and updated 25).

Each customer has an unique ID number so I am able to sort the data so as to
get the 'old' and 'new' data next to each other.

What I want to now is delete every row apart from the customers who have
updated details.

So I would be left with 50 records.

Thanks in advance.

Gareth

Delete unwanted rows
 

I was hoping not to have to insert another column, can it be done using
code?

"Ken Wright" wrote in message
...
With your data in A1:A1500, in cell B1 put the following formula and copy
down:-

=IF(COUNTIF($A$1:$A$1500,A1)1,"Keep Me","")

Now select all the data and sort on Col B in descending order.

Then just delete all the unwanted records at the bottom.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------------------------
--
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------------------------
--



"Gareth" wrote in message
...
I have a sheet of data which is made up of all customer details and
updated
ones (all is approx 1,500 and updated 25).

Each customer has an unique ID number so I am able to sort the data so
as to
get the 'old' and 'new' data next to each other.

What I want to now is delete every row apart from the customers who have
updated details.

So I would be left with 50 records.

Thanks in advance.

Gareth