# Continue more complex sequence

#### Jaymond Flurrie

##### Well-known Member
Everyone knows Excel can continue 1,2,3... to 4,5,6 and Monday, Tuesday, Wednesday to Thursday, Friday, Saturday. But what if the sequence is much more complex? Like for example, given list:
10
6,025
3,77
2,52
1,77
1,32
1,01
0,805
0,645
0,53
give me the 50th entry on that list. What's the function? That's exactly what I'm asking for.

#### mikerickson

##### MrExcel MVP
Unless you know how the sequence progresses, Excel can't predict the future values.

#### Jaymond Flurrie

##### Well-known Member
Unless you know how the sequence progresses, Excel can't predict the future values.
I kind of thought so - I probably need something more mathematical oriented program for that. Thanks for confirming though!

#### mikerickson

##### MrExcel MVP
Unless you know that a sequence is a particular type, ("linear", "logrhythmic", or ....), taking 10 numbers and trying to extrapolate the 50 is not likely to be accurate. In any program.

Last edited:

#### Jaymond Flurrie

##### Well-known Member
Unless you know that a sequence is a particular type, ("linear", "logrhythmic", or ....), taking 10 numbers and trying to extrapolate the 50 is not likely to be accurate. In any program.
But I think it can give with some accuracy. I can get more of those numbers to that list of known values too.

#### mikerickson

##### MrExcel MVP
Many data points are good for finding intermediate values, not for extrapolating the future unless (as stated above) the nature of the data collected tells one what kind of function the data is likely to follow.

BTW, you don't need to quote a post that you are immediately responding to, it just eats up screen space.

Last edited:

Threads
1,086,243
Messages
5,388,668
Members
402,134
Latest member
McKnze21