Figure out pattern, trend formula?

Erkjerk

New Member
Joined
Sep 24, 2017
Messages
36
Trying to figure out a way in excel to figure out a pattern. Below is the information but unable to figure the increase in numbers on right. Any help would be great!

Thank you

$ 450,000.00$ 180.00
$ 460,000.00$ 230.00
$ 470,000.00$ 280.00
$ 480,000.00$ 340.00
$ 490,000.00$ 400.00
$ 500,000.00$ 460.00
$ 510,000.00$ 530.00
$ 520,000.00$ 600.00
$ 530,000.00$ 670.00
$ 540,000.00$ 750.00
$ 550,000.00$ 830.00
$ 560,000.00$ 910.00
$ 570,000.00$ 990.00
$ 580,000.00$ 1,100.00
$ 590,000.00$ 1,210.00
$ 600,000.00$ 1,330.00
$ 610,000.00
$ 620,000.00
$ 630,000.00
$ 640,000.00
$ 650,000.00
$ 660,000.00
$ 670,000.00
$ 680,000.00
$ 690,000.00
$ 700,000.00
$ 710,000.00
$ 720,000.00
$ 730,000.00
$ 740,000.00
$ 750,000.00
$ 760,000.00
$ 770,000.00
$ 780,000.00
$ 790,000.00
$ 800,000.00
$ 810,000.00
$ 820,000.00
$ 830,000.00
$ 840,000.00
$ 850,000.00
$ 860,000.00
$ 870,000.00
$ 880,000.00
$ 890,000.00
$ 900,000.00
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
I think these could be the patterns:

varios 04jun2020.xlsm
ABCDE
1timesincrements
2450,000.00180.00
3460,000.00230.00502
4470,000.00280.0050
5480,000.00340.0060310
6490,000.00400.0060
7500,000.00460.0060
8510,000.00530.0070310
9520,000.00600.0070
10530,000.00670.0070
11540,000.00750.0080410
12550,000.00830.0080
13560,000.00910.0080
14570,000.00990.0080
15580,000.001,100.00110230
16590,000.001,210.00110
17600,000.001,330.00120310
18610,000.001,450.00120
19620,000.001,570.00120
20630,000.001,700.00130310
21640,000.001,830.00130
22650,000.001,960.00130
23660,000.002,100.00140410
24670,000.002,240.00140
25680,000.002,380.00140
26690,000.002,520.00140
27700,000.002,690.00170230
28710,000.002,860.00170
Hoja4
Cell Formulas
RangeFormula
B18:B28B18=B17+C18
 
Upvote 0

Forum statistics

Threads
1,215,376
Messages
6,124,593
Members
449,174
Latest member
chandan4057

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top