how do i remove multiple entries in an excel database?

[Chi]

In an inventory database, there are some repeat data, how can i remove these
redundant entries without manually seeking them out, (such as using lookup
functions) ?

 

[Norman Jones]

Hi Chi,

See Chip Pearson's page on duplicates for a variety of techniques for
handling duplicates:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates