ExcelBanter - Repeatition of the same item

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Repeatition of the same item (https://www.excelbanter.com/excel-discussion-misc-queries/87857-repeatition-same-item.html)

S.G.Pillai

Repeatition of the same item

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

Ardus Petus

Repeatition of the same item

DataValidationCustomized
Formula: =COUNTIF(A:A,A1)=1

HTH
--
AP

"S.G.Pillai" a écrit dans le message de
news: ...
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.
Thanks

All times are GMT +1. The time now is 05:38 PM.