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. Simi...
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.
- I figure it out now.
Thank you for your help.