Hi,

Is it possible to do a validation list with the last part of the cell in random numbers?

Example.

My list could be

Apple 1
Apple 2
Apple 3
Apple 4
Apple ....
...
..
..

In my range I may need to enter Apple up to 100 or more. I'm not sure what is the max I will reach. So I'm wondering if I can do something like "Apple*" of countif. Apparently I can;t do it...