ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i remove multiple entries in an excel database? (https://www.excelbanter.com/excel-discussion-misc-queries/58292-how-do-i-remove-multiple-entries-excel-database.html)

Chi

how do i remove multiple entries in an excel database?
 
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

how do i remove multiple entries in an excel database?
 
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) ?





All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com