May 13 2020 04:50 AM
Hi everyone, I'm trying to make a table of some names and I want to limit the users entering only 10 of the same name. I used data validation and countif function but it doesn't work. As you may guess I'm not that experienced in Excel so I appreciate any and every bit of help. Thanks in advance.
Example file is attached.
May 13 2020 05:15 AM
May 13 2020 05:18 AM
@mangatic Let's say you are entering names in column C then select column C and select Data Validation. Then choose "Custom" and enter the following formula:
=(countif(c:c,c1)<11)
that will make sure a max of 10 identical entries can be entered in col C.
you can also choose warning and custom messages to prompt to the user.
May 13 2020 05:34 AM
May 13 2020 05:37 AM
Thanks for replying but it didn't work. Got an error sayinG Common Function Mistake.
May 13 2020 05:39 AM
May 13 2020 06:27 AM
May 13 2020 05:24 AM
Solutionfile attached