Removing duplicate entries in Excel spreadsheet

baxy · Joined: 28 Aug 2003 Posts: 204

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.

rustie · Joined: 07 Dec 2007 Posts: 21

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.

H-Desk.com - PC Security matters - Protect your PC privacy

Removing duplicate entries in Excel spreadsheet

LIFEFORM SOCIAL COMMUNITY NETWORK