Forum Discussion
limit the inserts of certain word in one column
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.
5 Replies
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.
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.
