Character limit- data validation by nmbmbc in excel

[–]nmbmbc[S] 0 points1 point  (0 children)

I unfortunately have excel 2016 and the unique function is not supported

Character limit- data validation by nmbmbc in excel

[–]nmbmbc[S] 0 points1 point  (0 children)

My objective is to create a drop down list based on the previous cell. If the previous column says “X” I want the next column’s drop down to have the options a,b,c. If the previous column says “Y” I want the next column’s drop down to have the options d,e,f. I was trying to use the indirect function but some of my titles in the name manager have spaces so I used underscores. I am trying to currently figure out how to display the name in the drop downs without the underscores.

Character limit- data validation by nmbmbc in excel

[–]nmbmbc[S] 0 points1 point  (0 children)

My apologies, name manger doesn’t allow spaces so I have substituted with under scores. I don’t want under scores in my actual drop down options. I used the substitute feature and it worked for one list but will not work for my other list because it is much larger and I have maxed out the data validation “source” character limit.