string of numbers
 

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.

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

Thank you.
David

"BorisS" wrote:

is your question how to predict a pattern? Or if I am in the middle of the
string of cells, to have a cell right beneath that one show me what's in the
next one?
--
Boris


"David" wrote:

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.