close
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.
=if(countif(a:a,a25)gt;1,a25,quot;quot;)
Micki wrote:
gt;
gt; How do I compare the entry in one cell against all other cells in the same
gt; column, except the cell the entry is in, and make it display the entry in a
gt; different cell if it matches. I almost have it, but I'm getting all
gt; duplicates becuase the entry matches itself.
--
Dave Peterson
全站熱搜
留言列表
