Assuming the last number in your list is in A1, put this in B1 and drag down:-

=LEFT(A10,5)&MID(A10,FIND("/",A10,1)+1,99999999)+1

it will increment the numbers after the / by 1 up to 99999999

Mike

"Steve" wrote:

If i have a table of numbers in an array and want to find a number starting
with say first 4 digits and want it to tell me the next number in the
sequence, then how do i do it in excel if at all?

i.e.

if a list of numbers such as 1234/1, 1234/2, 1234/3....i want it to tell me
the next in the sequence is 1234/4..

any ideas?

its a pity you cant just think these thoughts in "help"...:)