string of numbers

D

David

I am wondering if there is a way in Excel to find what the next number will
be in a string.

Example:
I have a list of numbers, the lowest is 1 the highest is 10. I have tracked
it for over 500 times to get a good base. So the numbers go something like 5,
9, 2, 4, 6, 5, 8, 10, 1, etc. etc. (each number in it's on cell from A1
through A500)

My question is there a formula to find what the next number will be... sort
of a flow chart or graph it out.
 
D

David

It was more on the how to predict a pattern of a list of numbers between 1
and 10.

Thank you.
David
 
Top