Hi,
I have a problem. Anyone can help?
I have a worksheet (called Grocery) which has validation properties.
For example, in column C, i reference a validation list called Fruits.
So, in C1 through C10, there is a dropdown for me to select the fruits i specified in another worksheet under Name=Fruits.

So, this can happen :
C1 Apple
C2 Mango
C3 Banana
C4 Apple
C5 Apple

I want to perform either an auto-filter/Sort to see all Apples. But I am unable to do so, due to the validation list.

What should I do?