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



Micki wrote:

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.

--

Dave Peterson