Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to compare two excel files for repetitious cells?
I am trying to find a way to compare two excel files in order to find
duplicate numbers between the two files. I am listing serial numbers and need to make sure that there are no duplicates listed between more than one Excel file. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to compare two excel files for repetitious cells?
If there was a formula or auto lookup that could do this, I would be very interested as well. The only way I have done this is to create a third sheet and merge the two documents into one,(provided both files have the same format) but color coding one document before merging, and then sorting by the column that I want to look for duplicate values of. This isn't really effective if you have more than 500 rows however, but it gets the job done if you are working with smaller size files. -- darkwood ------------------------------------------------------------------------ darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948 View this thread: http://www.excelforum.com/showthread...hreadid=496450 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Export html page to Excel - support files folder | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) |