limit the inserts of certain word in one column

[bkunse]

Hi.

Can I limit the inserts of certain word in one column?

I am trying to limit inserts in certain column. For example the word "LD" can be written in each column only 5 times and not more. Similar to data validation.

Now I am using COUNTIF formula for counting, but it dosen´t prevent you to insert the word more than 5 times. 

Than you for your help.

[#2]

@bkunse See if you can replicate the example in the picture below.

The custom data validation used here is:

=COUNTIF($B$3:$B$20,"LD")<=5

Enter LD one more time in the applied range and you'll get an error message.

[#3]

@Riny_van_Eekelen 

I have tried that but it dosen´t prevent me from writing LD the 6th time.

[#4]

@bkunse Did you apply the data validation rule to the entire range of cells where you want to limit the entry of LD to max five times? Try the attached file.

[#5]

@Riny_van_Eekelen 

It works in yours but when I do the same in mine it doesn´t.

[#6]

I figure it out now.

Thank you for your help.