Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cross reference?
Hello there. Here is my problem. In one file, we'll call
file "A", there is a list of lets say 100,000 phone numbers. Now in file "B" there is a list of 50,000 phone numbers, some may match those is file "A" and some may not. I need a way to combine those two files and have only the numbers in file "A" that didn't match with the numbers in file "B" go into some sort of group of their own. Is this do-able?? Kelly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cross reference?
Given the size of your lists, I think excel is not really the product. Load the data into MSaccess and run the 'Find duplicates query wizard' and 'Find unmatched query wizard' They are intended to solve just your problem. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross Reference | Excel Worksheet Functions | |||
cross reference | New Users to Excel | |||
Cross reference | Excel Discussion (Misc queries) | |||
cross reference two | New Users to Excel | |||
Cross Reference | Excel Worksheet Functions |