Trying to create Macro to delete duplicate Rows

D

Dennis

Hello,

I am hoping someone can help me. I am not an experienced macro writer and I
am having a problem on how to write a macro on deleteing duplicate rows. To
give you an example of what i am trying to do is:

I am trying to delete rows with duplicate information that is in column
A,S,T,U,V,W, Y, and Z.

But i want to leave at least one row with that info.

For example if row 1, 2, and 3 have the same info in A, S, T, U, V, W, Y,
and Z. I would want to leave row 1 and delete row 2 and 3.

I am hoping someone can help.

Thanks
 
P

paul.robinson

Hi
This is one of the most common questions asked. Please search this
group with "delete duplicate rows" and you will see many hundreds of
past emails to work from.
regards
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Concatenate Group of Rows 2
Comparing Rows 9
Delete duplicate rows of data 2
Group 1
delete rows that have a duplicate id keeping the upper row 6
How to Delete duplicate row access 2003 0
Unmerge cells and fill duplicate data 5

Top