Hi Chi,

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

http://www.cpearson.com/excel/duplic...tingDuplicates


---
Regards,
Norman


"Chi" wrote in message
...
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) ?