I have a file which has account numbers. There are duplicate account numbers throughout the sheet - 2000-3000 rows of information.
I want to write a program which will find all the duplicates, mark them for deletion, and then remove the rows.
I can do everything except find the duplicates.
I know how to use the Match command, but it only returns the first match in an array. I need to identify all matches. Is there something which can do that?
I want to write a program which will find all the duplicates, mark them for deletion, and then remove the rows.
I can do everything except find the duplicates.
I know how to use the Match command, but it only returns the first match in an array. I need to identify all matches. Is there something which can do that?