Hi guys, need some help with Excel formula and/or data validation.
I have two columns with multiple rows. For each row, the first column will have only two options "Yes, No", which I gave options using data validation by writing "yes, no" in another hidden sheet.
Now for second column, there are...