close

I want to avoid repeatition of the tags in the rows i am entering. ie.. if i
have entered 98TI-107 once it should notify me if i am trying to enter it
once again.
ThanksDatagt;Validationgt;Customized
Formula: =COUNTIF(A:A,A1)=1

HTH
--
AP

quot;S.G.Pillaiquot; gt; a écrit dans le message de
news: ...
gt;I want to avoid repeatition of the tags in the rows i am entering. ie.. if
gt;i
gt; have entered 98TI-107 once it should notify me if i am trying to enter it
gt; once again.
gt; Thanks
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()