removing duplicate rows

E

exceluser2

Ho do I remove duplicate rows in excel yet still keep a row but not th
duplicates
 
G

Guest

Which column(s) are you comparing to identify duplicates? If A1 = A2, are
rows one and two duplicates? Or A1 & B1 = A2 & B2? Or A1 & B1 &C1 = A2 & B2 &
C2?
Do you have a header row?
 
E

exceluser2

If in a row all cells match another row it would be a duplicate. Even
the header row is duplicated. A1 & B1 &C1... = A2 & B2 & C2... 150
cells per row
 
G

Guest

Checking for an entire duplicate row is beyond my ability.
If we can check the first several columns in one row against several columns
in another row, we can easily delete duplicates. Might this work?
 

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
duplicating rows 1
Deleting Duplicate cells function 1
removing duplicate rows from access? 3
remove duplicates but retain one not delete both 4
delete duplicate rows, keep one 1
How to Delete duplicate row access 2003 0
Delete duplicate and original row 3

Top