Forum Discussion
can you please help on data validation rule( picklist validation)
I have three columns, each column consists of picklist yes and NO.
If i select any one of the column yes, remaining two columns should be No.
Example : nokia iphone samsung
1) yes no . no
2) no yes no
3) no no yes
please help me
1 Reply
Hi Anu,
I'd make it easy on yourself, and use a single column with a drop-down list for Nokia, iPhone, and Samsung. Otherwise, you need a VBA Change event to add the No/No entries. You also have a structure that doesn't lend itself to easy reporting, whereas a PivotTable will give you a reporting output like the input structure you have now, and it will be much more dynamic.
This setup also works better, because you can easily add more brands to the list options, instead of adding new columns. With a single column, you have 3 entries for 3 items, instead of 9 like your example, so it's going to be more efficient.
HTH
