Spreadsheet: 270245d1381422249-create-a-linear-equation-to-fill-in-blank-cells-in-a-column-excel-help-template
Sheet: Excel Help Template

815946 |  | -1.668 | -0.932
815947 |  |  | -0.9362
815948 |  | -1.668 | -0.9404 |  | Need to fill in the values by finding the difference between the two values and then divide it by the number of cells between the two values.
815949 |  |  | -0.9446 |  |  | -0.932+ -0.953= 0.021 / 5 = 0.0042 |  |  |  | Factor of 0.0042 is added to the original value to fill the blanks.
815950 |  |  | -0.9488
815951 |  |  | -0.953
815952
815953 |  |  | -0.967
815954
815955 |  |  |  |  | I plan on sorting the document by column D to get all the values grouped and all the blank cells grouped.  Then I want to paste the formula
815956 |  | -1.668 |  |  | into all the blank D coulmn cells and then resort by column A so the formula is between all the hard coded values.  I would then do the same process
815957 |  |  |  |  | with column C.
815958 |  | -1.67
815959
815960
815961 |  | -1.672
815962
815963 |  | -1.684
815964
815965
815966 |  |  | -0.994
815967
815968 |  |  | -0.991
815969
815970 |  | -1.687
815971
815972
815973 |  | -1.69
815974
815975 |  | -1.692
815976
815977
815978 |  | -1.712
815979
815980 |  | -1.721
815981
815982
815983 |  | -1.709
815984
815985 |  |  | -0.987
815986
815987 |  |  | -1.002
815988
815989
815990 |  | -1.716
815991
815992 |  | -1.713
815993
815994
815995 |  | -1.696
815996
815997 |  | -1.706
815998
815999
816000 |  | -1.735
816001
816002 |  |  | -0.979
816003
816004
816005 |  |  | -0.981
816006
816007 |  | -1.717
816008
816009 |  | -1.722
816010
816011
816012 |  | -1.72
816013
816014 |  | -1.73
816015
816016
816017 |  |  | -1.002
816018
816019 |  | -1.747
816020
816021
816022 |  |  | -1.012
816023
816024 |  |  | -1.011
816025
816026 |  | -1.736
816027
816028
816029 |  | -1.731
816030
816031 |  | -1.738
816032
816033
816034 |  | -1.737
816035
816036 |  | -1.749
816037
816038
816039 |  |  | -1.005
816040
816041 |  |  | -1.007
816042
816043
816044 |  | -1.741
816045
816046 |  | -1.74
816047
816048 |  | -1.739
816049
816050
816051 |  | -1.736
816052
816053 |  | -1.742
816054
816055
816056 |  | -1.75
816057
816058 |  |  | -1.012
816059
816060
816061 |  |  | -1.008
816062
816063 |  | -1.735
816064
816065
816066 |  | -1.746
816067
816068 |  | -1.746
816069
816070 |  | -1.741
816071
816072
816073 |  | -1.739
816074
816075 |  | -1.735
816076
816077
816078 |  |  | -1.026
816079
816080 |  | -1.734
816081
816082
816083 |  | -1.735
816084
816085 |  | -1.732
816086
816087 |  | -1.739
816088
816089
816090 |  | -1.748
816091
816092 |  | -1.741
816093
816094
816095 |  |  | -1.005
816096
816097 |  |  | -1.018
816098
816099
816100 |  | -1.732
816101
816102 |  | -1.731
816103
816104
816105 |  | -1.74
816106
816107 |  | -1.752
816108
816109 |  | -1.757
816110
816111
816112 |  |  | -1.008
816113
816114 |  |  | -1.008
816115
816116
816117 |  |  | -1.022
816118
816119 |  | -1.748
816120
816121
816122 |  | -1.746
816123
816124 |  | -1.736
816125
816126 |  | -1.742
816127
816128
816129 |  | -1.754
816130
816131 |  | -1.742
816132
816133
816134 |  |  | -1.002
816135
816136 |  |  | -1.014
816137
816138
816139 |  | -1.748
816140
816141 |  | -1.743
816142
816143
816144 |  | -1.738
816145
816146 |  | -1.744
816147
816148 |  | -1.76
816149
816150
816151 |  |  | -1.019
816152
816153 |  |  | -1.027
816154
816155
816156 |  | -1.735
816157
816158 |  | -1.741
816159
816160
816161 |  | -1.737
816162
816163 |  | -1.748
816164
816165 |  | -1.749
816166
816167
816168 |  |  | -1.016
816169
816170 |  |  | -1.013
816171
816172
816173 |  | -1.742
816174
816175 |  | -1.742
816176
816177
816178 |  | -1.744
816179
816180 |  | -1.76
816181
816182
816183 |  | -1.768
816184
816185 |  |  | -1.013
816186
816187 |  |  | -1.01
816188
816189
816190 |  | -1.751
816191
816192 |  | -1.752
816193
816194
816195 |  | -1.732
816196
816197 |  | -1.742
816198
816199
816200 |  | -1.757
816201
816202 |  |  | -1.019
816203
816204
816205 |  |  | -1.018
816206
816207 |  | -1.74
816208
816209 |  | -1.746
816210
816211
816212 |  | -1.744
816213
816214 |  | -1.742
816215
816216
816217 |  | -1.747
816218
816219 |  |  | -1.025
816220
816221
816222 |  |  | -1.029
816223
816224 |  | -1.738
816225
816226 |  | -1.733
816227
816228
816229 |  | -1.751
816230
816231 |  | -1.75
816232
816233
816234 |  | -1.761
816235
816236 |  |  | -1.016
816237
816238
816239 |  |  | -1.019
816240
816241 |  | -1.746
816242
816243
816244 |  | -1.724
816245
816246 |  | -1.744
816247
816248 |  | -1.748
816249
816250
816251 |  | -1.759
816252
816253 |  |  | -1.023
816254
816255
816256 |  |  | -1.025
816257
816258 |  | -1.738
816259
816260
816261 |  | -1.739
816262
816263 |  | -1.733
816264
816265 |  | -1.747
816266
816267
816268 |  | -1.75
816269
816270 |  |  | -1.022
816271
816272
816273 |  |  | -1.032
816274
816275 |  | -1.728
816276
816277
816278 |  | -1.729
816279
816280 |  | -1.743
816281
816282
816283 |  | -1.748
816284
816285 |  | -1.743
816286
816287 |  |  | -1.013
816288
816289
816290 |  |  | -1.018
816291
816292 |  | -1.736
816293
816294
816295 |  | -1.738
816296
816297 |  | -1.732
816298
816299
816300 |  | -1.738
816301
816302 |  | -1.754
816303
816304
816305 |  |  | -1.023
816306
816307 |  |  | -1.016
816308
816309 |  | -1.731
816310
816311
816312 |  | -1.743
816313
816314 |  | -1.732
816315
816316
816317 |  | -1.733
816318
816319 |  | -1.736
816320
816321
816322 |  |  | -1.006
816323
816324 |  |  | -1.018
816325
816326 |  | -1.715
816327
816328
816329 |  | -1.709
816330
816331 |  | -1.721
816332
816333
816334 |  | -1.73
816335
816336 |  | -1.724
816337
816338
816339 |  |  | -1.013
816340
816341 |  |  | -1.022
816342
816343
816344 |  | -1.715
816345
816346 |  | -1.712
816347
816348 |  | -1.733
816349
816350
816351 |  | -1.737
816352
816353 |  | -1.74
816354
816355
816356 |  |  | -1.017
816357
816358 |  |  | -1.029
816359
816360
816361 |  | -1.723
816362
816363 |  | -1.71
816364
816365 |  | -1.719
816366
816367
816368 |  | -1.733
816369
816370 |  | -1.728
816371
816372
816373 |  |  | -1.005
816374
816375 |  |  | -1.004
816376
816377
816378 |  | -1.734
816379
816380 |  | -1.736
816381
816382
816383 |  | -1.731
816384
816385 |  | -1.735
816386
816387 |  | -1.722
816388
816389
816390 |  | -1.711
816391
816392 |  | -1.723
816393
816394
816395 |  | -1.708
816396
816397 |  |  | -1.014
816398
816399
816400 |  | -1.724
816401
816402 |  | -1.72
816403
816404 |  |  | -1.016
816405
816406
816407
816408
816409
816410
816411
816412
816413
816414
816415
816416
816417
816418
816419
816420
816421
816422
816423
816424
816425
816426
816427
816428
816429
816430
816431
816432
816433
816434
816435
816436 |  | -1.74