Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with macro to save repeating data entry | Excel Discussion (Misc queries) | |||
How to insert a repeating dash in phone numbers without dashes in. | New Users to Excel | |||
Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
macro to eliminate spaces between words | Excel Discussion (Misc queries) | |||
How do I delete 100 account numbers from a spreadsheet colume wer. | Excel Worksheet Functions |