Avoid Duplication In Excel By Ensuring Unique Values

Billy has just bought a job lot of hundreds of ex-rental films on DVD with the intention of starting up a DVD rental business of his own. His first, rather laborious task is to log all of the titles in an Excel spreadsheet. As the DVDs are ex-rental, they already have numbered stickers on them and so Billy decides to log the titles using these existing numbers. This makes sense, as it will save him the trouble of renumbering the entire stock and putting new stickers onto each disc, with a corresponding one on each box.

The full article appears here:
http://www.microsofttraining.net/article-1824-avoid-duplication-in-excel-by-ensuring-unique-values.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com