Stop when putting duplicate word.

[Salamullah]

Dear Experts.

I want any condition/formula which can stop putting same word in a particular column.


Apple
Banana
Orange
Apple (Stop) word already exist

 

[Coding4Fun]

Highlight the column you want to not allow duplicates in, in my example I used column F

With the column highlighted, go to the Data tab, in the Data Tools section choose Data Validation.

In the window provided Allow: Custom, and insert this formula =COUNTIF(F:F,F1)<=1

 

[Salamullah]

Hi Coding4Fun,

Its perfect !!!

Many thanks for the quick solution.