How do I compare the entry in one cell against all other cells

M

Micki

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.
 
D

Dave Peterson

=if(countif(a:a,a25)>1,a25,"")


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.
Click to expand...
 
Top