• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DUPLICATE LINES IN EXCEL

J

jitendra.wankhede

New Member
DEAR,


I have an assignment of sorting 20000 lines in which duplicates lines are indicated

with same description Pls give me the fantastic idea about same.
 
Highlight the data, and sort. Then, in column next to data, next to the 2nd item in list, do something like:

=IF(A3=A2,"Duplicate","")


Copy down as needed.
 
Hi Jitender,


Or else you can also you conditional formating to highlight the duplicates.


Home --> Conditional Formatting --> Highlight Cell values --> Duplicate Values.
 
You must log in or register to reply here.
Back
Top