Does anyone know a simple way to identify and remove duplicate rows from an Excel 2000 database? I've a database that's about 6000 rows long and 8 columns wide, and some of the rows are duplicates of one another. I really don't fancy the task of going through it all by hand.
you shouldnt be using excel as a database in the first place. think about using access instead, even for a simple single table dbase it is much better. access also has a find duplicates query wizard
Eamonn, do you not think excel is far easier for small DBs like office asset registers and the like of anything taking no more then 5-6k records.
A few locks on the sheet, a small form to enter the data and youre away. Its easier for users to query with the later versions of office too (conditional formatting etc). I dont know what its like now, but back in the day, I hated building anything in access.
caveat: Amonst other things Im in DB design too. (oracle and sql server)