macro to eliminate repeating account numbers
 

Hello -

I have report that shows customer account numbers and the date transactions
occurred for that account. Some customers have more than one row on my
spreadsheet because they have made more than one transaction.

I only want to show the FIRST transaction each customer made and delete each
subsequent one for each customer.

Macros are fairly new to me, but what I want to do is sort the spreadsheet
by account number, then transaction date (I know how to make the macro do
that part) and then program the macro to delete any duplicate transaction
rows per customer, leaving just that original transaction.

I would really appreciate any help in accomplishing this. Thanks!

Use Autofilter

Assuming your data in column A, add this formula to B1

=COUNTIF($A$1:A1,A1)1

and copy down.

Then apply a filter to column B (DataAutofilter). Click the dropdown,
select TRUE, and then delete the visible rows. Remove Autofilter, and it is
done.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sarah" wrote in message
...
Hello -

I have report that shows customer account numbers and the date
transactions
occurred for that account. Some customers have more than one row on my
spreadsheet because they have made more than one transaction.

I only want to show the FIRST transaction each customer made and delete
each
subsequent one for each customer.

Macros are fairly new to me, but what I want to do is sort the spreadsheet
by account number, then transaction date (I know how to make the macro do
that part) and then program the macro to delete any duplicate transaction
rows per customer, leaving just that original transaction.

I would really appreciate any help in accomplishing this. Thanks!

That worked perfectly! Thanks so much!

"Sarah" wrote:

Hello -

I have report that shows customer account numbers and the date transactions
occurred for that account. Some customers have more than one row on my
spreadsheet because they have made more than one transaction.

I only want to show the FIRST transaction each customer made and delete each
subsequent one for each customer.

Macros are fairly new to me, but what I want to do is sort the spreadsheet
by account number, then transaction date (I know how to make the macro do
that part) and then program the macro to delete any duplicate transaction
rows per customer, leaving just that original transaction.

I would really appreciate any help in accomplishing this. Thanks!