View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Micki
 
Posts: n/a
Default How do I compare the entry in one cell against all other cells

How do I compare the entry in one cell against all other cells in the same
column, except the cell the entry is in, and make it display the entry in a
different cell if it matches. I almost have it, but I'm getting all
duplicates becuase the entry matches itself.