Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chi
 
Posts: n/a
Default 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) ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default 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) ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Drop Down box or check box data to Excel Database TotallyConfused Excel Discussion (Misc queries) 3 October 26th 05 05:36 PM
multiple items in database Peter Excel Worksheet Functions 2 June 15th 05 08:19 PM
How do I use Excel to post data to an external database? ctimrun Excel Discussion (Misc queries) 0 June 14th 05 05:39 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Open Access Database under and Excel window using a Macro BMSpell Excel Worksheet Functions 1 January 8th 05 05:32 PM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"