Entering numbers using specific condition

New Contributor

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

2 Replies
best response confirmed by shubhamsonawane (New Contributor)

@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.