Formula to find and list duplicates
I have two columns consisting of 1000 cells that each have 7 digits. For
example
8956743 8658237
8967842 8753689
8974389 8896536
These two columns share some of the same numbers. I want to find and LIST
all of these shared numbers. Some of these numbers are the same and some are
different. I just need a formula to find the duplicates. HELP ME!!
|