Hello I have two columns of drop down lists with 5 options in each list- LIST1 (apple,orange,banana...) and the second list LIST2(a, b , c...)
I want to count when one option from the first list matches for option from the second list.
For example if I chose Banana from list 1 and a from list 2 I should get 1.
then Again I chose banana from list 3 and a from list 4 now it should be 2 and so on.
But if he chose Banana from list 1 and c from list 2 it shouldn't count.
Hope you understand me and you have a solution.
THANKS
I want to count when one option from the first list matches for option from the second list.
For example if I chose Banana from list 1 and a from list 2 I should get 1.
then Again I chose banana from list 3 and a from list 4 now it should be 2 and so on.
But if he chose Banana from list 1 and c from list 2 it shouldn't count.
Hope you understand me and you have a solution.
THANKS