How to find duplicates from excel spreadsheet

Steps
1) Select the area you wish to be included in the search
2) On home tab click on Conditional Formatting > Highlight Cell rules > Duplicate Values (See the image below for help)

3) All the values will be...

Asslam O Alikum:


Dear Friend,

Sir mjy excel mi msla ho rha hai k cell mi CNIC Number likha hi36201-0471064-5 es mi dash (-) show ho rhi hin likn jb es ko formula bar mi dikhta hon tu whna show ni hota plz es k bary mi kuch batin.

Formating...