I really can’t figure this out. I just made a dropdown list using the Data > Validation which the source was targeted in a diffrent worksheet. What I wanted to do is to assign each choices in the dropdown menu with a specific numerical value.
eg. if the selected choice in the dropdown is “Apple”, then the value of “Apple” is “1” or if the choice is “Banana”, then the value of “Banana” is “2” and after that, it will summarize how many people in the list chose “Apple” and the “Banana”.
Is this possible?
