While working with huge data tables in Excel there are times when your data may contain duplicate records. To eliminate the confusions that duplicate records may result into and to avoid unnecessary increase in physical size of the spreadsheet it is better to find and remove the duplicate records. Today I will be sharing five easy and effective ways by which you can identify and remove duplicate records in Excel.