Backboards: 
Posts: 154
In response to "Excel help pls! I know how to remove duplicates in Excel, but how do I easily find duplicates?" by ty97

I usually do a formula. Sort by the column where the duplicate occurs (say, col A)

then in a new column in row 2,
=IF(A2=A1,"DUPLICATE","")
and copy down


Post a message   top
Replies are disabled on threads older than 7 days.