Forum Discussion
Entering numbers using specific condition
Hello everyone,
Does anyone know how to enter three digit numbers formed using specific digits only in excel?
eg. Three digit numbers formed using the digits 2,3,4,5,6 only.
Please let me know
shubhamsonawane I came up with a formula that can test the numbers entered, but Data Validation doesn't accept such a formula a a custom condition. Therefor, I added a helper column (can be hidden) and referred the custom data validation rule to these helper cells. See attached.
2 Replies
shubhamsonawane I came up with a formula that can test the numbers entered, but Data Validation doesn't accept such a formula a a custom condition. Therefor, I added a helper column (can be hidden) and referred the custom data validation rule to these helper cells. See attached.
- Thank you so much Riny_van_Eekelen. That was helpful.
