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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
marking duplicates between two files
You can try the countif function as follows:
In file 1 add a formula in a blank column to be =countif($A$1:$A $100,a1) Modify the range to be what ever you need Any value returned by countif 1 is a duplicate. On Nov 11, 7:09 pm, JCM wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
marking duplicates between two files
thanks, I'll try that but will the count if also count the dulplicates within the column? I really only want it to count between the two spreadsheets. "Tim879" wrote: You can try the countif function as follows: In file 1 add a formula in a blank column to be =countif($A$1:$A $100,a1) Modify the range to be what ever you need Any value returned by countif 1 is a duplicate. On Nov 11, 7:09 pm, JCM wrote: 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. |
Reply |
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 |