Validation list with change numbers behind?

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

Originally Posted by pike

Hi Lewis Koh,
what are you trying to do?

I want to make a drop down list to choose Apple 1, Apple 2, Apple 3, Apple 4.....Apple "N" where N could be infinity.

Assuming your data start in sheet1!A1

Create a defined name range call MyRange
=Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A))

Validation
Allow: select List
Source: =MyRange

oh, I'm sorry.

Hmm.....did I confused everyone again? er...I wanted to make a list to select Issue 1 to n where n is still an unknown number.