I Have a spread sheet with Dependent Data validation list.
There are 3 type of Categories:
Category_A+
Category_A
Category_B
Dependent list is showing up for all except Category_A+ due to + symbol. I am using Indirect function for Dependent Validation.
Can any one help me with a Formula which would list the category with + symbol...
Bookmarks