markstro
Board Regular
- Joined
- Sep 8, 2008
- Messages
- 106
Using this formula from another post, how can I identify the location of the duplicate entry??
=IF(COUNTIF(A2:$A$521,A2)>1,"DUPLICATE","")
I have identified a lot of duplicates, finding them is another problem.
I cannot simply sort and delete as each row has data I have to incorporate into one row before I delete the other.
=IF(COUNTIF(A2:$A$521,A2)>1,"DUPLICATE","")
I have identified a lot of duplicates, finding them is another problem.
I cannot simply sort and delete as each row has data I have to incorporate into one row before I delete the other.