I hope that someone will be able to help me with problem in Microsoft Excel 2003. I receive several spreadsheets on daily basis. They are filled with duplicate numbers (which is fine). The problem is that I have to filter those records and give only unique records to my boss. Is there any way to remove duplicate entries in Excel spreadsheet.
Hello there. It is easy to remove duplicate entries in Excel spreadsheet. When you open Excel spreadsheet that has duplicates go to Data menu and select Filter – Advanced Filter. In dialog box choose Unique Records and your problem will be solved. I hope that this answer was what you were looking for. I think it is the easiest way but if someone has better idea I will be glad to hear it.