looking for duplicates
If you have 2007 excel then under the data tab in the data tools section you
can apply a function called "Remove Duplicates"
"John" wrote:
I have a spreadsheet that has several thousand rows. I want to be able to
run a macro, or something, that will go through column A and return ONLY the
rows that have duplicate values in column A and delete all the other rows.
How would I do this???
Thanks in advance
|