Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
marking duplicates between two files
I have two files with about 10,000 rows. Each one has a column that has
duplicates in each column so conditional formating does not help me find a duplicate between the files. I would like to add a column where I can indicate which values are duplicates between the two files. Access will not work because there is no common link. I would like to have a value which indicates which rows are duplicates so I can sort them and get them to the top of the file. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marking up pricing | Excel Discussion (Misc queries) | |||
Finding and marking duplicates | Excel Discussion (Misc queries) | |||
sum limit and marking | Excel Worksheet Functions | |||
Find duplicates between multiple XLS files | Excel Discussion (Misc queries) | |||
Marking Duplicates | Excel Worksheet Functions |