View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlotte B Charlotte B is offline
external usenet poster
 
Posts: 1
Default 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!!