View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn Marilyn is offline
external usenet poster
 
Posts: 211
Default Finding Repeated Items in Excel 2003

I'm working on a Spreadsheet where Column A and Column B are filled with
E-mail addresses. I created the following formula to find out what E-mail
address in Column A repeats in Column B and vice versa, but it does not work:
=ISNA(MATCH(B2,$A$2:$A4661,FALSE)) All i get is True for everything
including the blank cells.
I try to do the reverse and see what e-mail address in each column does not
repeat, but it did not work.

Any Help?

Thanks,