delete duplicate rows, keep one

G

Gary''s Student

Very simple. Say we have 150 rows. Starting with row # 150, compare each
cell in row #150 with the cells in the rows above it. If for some earlier
row, all the cells match, then delete row #150 and repeat the process moving
upwards.
 

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

Duplicate pst, or is it? 1
Duplicate Rows 2
Macro to delte Duplicate rows across multiple sheets 0
One Note links "error message 0
Dealing with a Pivot Table (when I don't want to) 0
Change Style to 'Keep with previous' instead of Keep with Next 1
Delete duplicate and original row 3
remove duplicates but retain one not delete both 4

Top