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...
Bookmarks