Remove Duplicate Data Records in Excel 2007
Wednesday May 20, 2009
The other day I received two pieces of mail from the same company. The envelopes contained the same information, they arrived on the same day, and both, obviously, used the same street address.
The only difference was that one address used my full name and the other just my first initial and last name.
Now, I'm sure the company didn't intend to send me the information twice, but they did because I am entered into their mailing list twice.
Spreadsheet programs such as Excel are often used as databases for things like parts inventories, catalogs of books or DVD’s, as well as mailing lists.
Keeping these databases free of duplicate data can be a big job, especially as they increase in size. To prevent errors caused by duplication in your spreadsheets, read the article on how to Remove Duplicate Data Records in Excel 2007.
Related Articles
The only difference was that one address used my full name and the other just my first initial and last name.
Now, I'm sure the company didn't intend to send me the information twice, but they did because I am entered into their mailing list twice.
Spreadsheet programs such as Excel are often used as databases for things like parts inventories, catalogs of books or DVD’s, as well as mailing lists.
Keeping these databases free of duplicate data can be a big job, especially as they increase in size. To prevent errors caused by duplication in your spreadsheets, read the article on how to Remove Duplicate Data Records in Excel 2007.
Related Articles
Comments
No comments yet. Leave a Comment