delete duplicate rows, keep one

  • Thread starter Thread starter Wasdell
  • Start date Start date
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 Rows 2
How to Delete duplicate row access 2003 0
remove duplicates but retain one not delete both 4
Delete duplicate and original row 3
Formula to Delete Duplicates but keep one record 4
Duplicates Deletion ? 2
Eliminate Duplicate Row 1
Delete Row if column has duplicate value 1

Back
Top