Finding duplicate in excel

Hi @Fresher

Please check this posts might help you,

How to remove rows with duplicates (Excel)
How to get count of unique values in column2 of the datatable - #8 by MAHESH1

Thanks
Latika