Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
string of numbers | Excel Worksheet Functions | |||
Removing numbers from the beginning of a text string | Excel Worksheet Functions | |||
extracting numbers from string | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions |