Nobby_the_Mouse
New Member
- Joined
- Apr 24, 2016
- Messages
- 7
Dear Excel brains of the world,
I have a data validation conundrum; spent an hour looking for a solution to no avail
I have the following list of values:
AR, ARNC, ARNF, ARSAP, B, C, E, ER, ES, N, T, V
To prevent user error, I need to be able to add a Data Validation rule into the columns' cells to allow any combination of the above to be successfully entered, separated by commas. Examples of successful entries could therefore be...
AR, B, V
ES, ARSAP, V, E, C, B
ES
ER, T
...you get the idea; I hope!
This is for a charity project to conserve reptile species, so your help would be much appreciated
Cheers,
Ben
I have a data validation conundrum; spent an hour looking for a solution to no avail

I have the following list of values:
AR, ARNC, ARNF, ARSAP, B, C, E, ER, ES, N, T, V
To prevent user error, I need to be able to add a Data Validation rule into the columns' cells to allow any combination of the above to be successfully entered, separated by commas. Examples of successful entries could therefore be...
AR, B, V
ES, ARSAP, V, E, C, B
ES
ER, T
...you get the idea; I hope!
This is for a charity project to conserve reptile species, so your help would be much appreciated

Cheers,
Ben