| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula for finding next number in a given sequence?
I would like to know if there is a formula that can determine what number
comes next in a sequence of given numbers. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel formula for finding next number in a given sequence?
Ummm... N + 1?
How about more information... doco "Rod" wrote in message ... I would like to know if there is a formula that can determine what number comes next in a sequence of given numbers. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel formula for finding next number in a given sequence?
Unless you know before hand whether the sequence is Arithmetic or Geometric, you may have a very tough time writing a macro to figure it out by testing data in cells. You could assume it to be Arithmetic and take the difference between the last two cells and add it to the value in the last cell to get the next value, but... -------------------- Ben  -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=535786 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel formula for finding next number in a given sequence?
You might find
http://www.research.att.com/~njas/sequences/ useful. If that is not what you are asking, then reply back with more complete description. Jerry "Rod" wrote: I would like to know if there is a formula that can determine what number comes next in a sequence of given numbers. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I generate a Sequence Number System in Excel? | Excel Discussion (Misc queries) | |||
| how can I put a number from a sequence in every row in excel? | Excel Worksheet Functions | |||
| Finding the longest sequence of 0's in a row | Excel Worksheet Functions | |||
| Is there an formula to reverse the order of a number sequence? | Excel Discussion (Misc queries) | |||
| Finding numbers missing from a sequence | Excel Discussion (Misc queries) | |||
Linear Mode
