View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Wilson Frank Wilson is offline
external usenet poster
 
Posts: 2
Default Find Duplicate Entries

I have a list in column A and a list in column B. I would
like to have a macro that compares the two lists and then
records duplicate entries in column C and unique entries
in column D. Would anyone have a macro / macros that
would do this?

P.S. I know that this can be done with array formulas.
However, the data set is so large that the arrays did not
properly calculate. I would prefer code if possible.