Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Deduping data
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Deduping data
Resolved · Low Priority · Version 2003
Reply
Deduping data
Is it possible to dedupe 2 excel files files against each other by using fields company name and postcode? they're quite large data sets and I'm not sure if excel can do this? Thank youFor upcoming training course dates see: Pricing & availability
RE: Deduping data
Hi Liz,Thank you for your question.
There is no specific way of doing this in Excel 2003. However there is a method using Autofilter that you could try.
I have included a hyperlink to a Microsoft site explaining the Autofilter method:
http://office.microsoft.com/en-us/excel/HA010346261033.aspx
There are also formulas you can try such as:
=IF(AND(B3=B4,C3=C4),"delete","don't delete")
Here is a link to some other formulas you could try:
http://www.microsoft.com/office/community/en-us/default.mspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=30769C6D-0DC9-4670-BF95-BE79BC8201F7&mid=30769C6D-0DC9-4670-BF95-BE79BC8201F7
I hope this answers your question.
Regards
Simon
Mon 7 Dec 2009: Automatically marked as resolved.
|
 |
|
» Forum post: Excel |
How is the easiest way to Count the number of Items in a list which are words. For example if you had a list of Hotels in London and Edinburgh, how can you easily count the london entries, without putting in an extra column with 1 in it?
