Spread & rollup

p748r · Nov 8, 2018

Hi, I need your help.

I have to recalculate the amount of stores and mouths, but without a tool is impossible for me.

The 2 immutable parameters (in blue) are:

. Sales per Store per Year
. The total month for all stores

Thanks.
<gs id="00bee639-f728-4141-b16d-d6d5324a091b" ginger_software_uiphraseguid="56f3a09c-3c3d-4d8b-81d3-295422cf69e6" class="GINGER_SOFTWARE_mark">.</gs>p.

[TABLE="width: 1399"]
<colgroup><col width="103" style="width: 77pt;"><col width="99" span="12" style="width: 74pt;"><col width="108" style="width: 81pt;"></colgroup><tbody>[TR]
[TD="class: xl112, width: 103"][/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Jan[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Feb[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Mar[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Apr[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] May[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Jun [/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Jul[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Aug[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Sep[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Oct[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Nov[/TD]
[TD="class: xl114, width: 99, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] Dec[/TD]
[TD="class: xl108, width: 108, align: center"]TOTAL[/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE1[/TD]
[TD="class: xl111"] 46.149 [/TD]
[TD="class: xl111"] 36.919 [/TD]
[TD="class: xl111"] 41.021 [/TD]
[TD="class: xl111"] 44.098 [/TD]
[TD="class: xl111"] 53.841 [/TD]
[TD="class: xl111"] 53.841 [/TD]
[TD="class: xl111"] 56.404 [/TD]
[TD="class: xl111"] 32.817 [/TD]
[TD="class: xl111"] 36.407 [/TD]
[TD="class: xl111"] 28.715 [/TD]
[TD="class: xl111"] 25.638 [/TD]
[TD="class: xl111"] 46.149 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 502.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE2[/TD]
[TD="class: xl111"] 61.422 [/TD]
[TD="class: xl111"] 51.185 [/TD]
[TD="class: xl111"] 79.337 [/TD]
[TD="class: xl111"] 102.370 [/TD]
[TD="class: xl111"] 81.896 [/TD]
[TD="class: xl111"] 66.540 [/TD]
[TD="class: xl111"] 76.777 [/TD]
[TD="class: xl111"] 46.720 [/TD]
[TD="class: xl111"] 56.303 [/TD]
[TD="class: xl111"] 37.365 [/TD]
[TD="class: xl111"] 30.711 [/TD]
[TD="class: xl111"] 59.374 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 750.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE3[/TD]
[TD="class: xl111"] 32.653 [/TD]
[TD="class: xl111"] 17.857 [/TD]
[TD="class: xl111"] 23.469 [/TD]
[TD="class: xl111"] 34.694 [/TD]
[TD="class: xl111"] 26.531 [/TD]
[TD="class: xl111"] 28.571 [/TD]
[TD="class: xl111"] 21.939 [/TD]
[TD="class: xl111"] 20.408 [/TD]
[TD="class: xl111"] 18.367 [/TD]
[TD="class: xl111"] 20.408 [/TD]
[TD="class: xl111"] 24.490 [/TD]
[TD="class: xl111"] 30.612 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 300.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE4[/TD]
[TD="class: xl111"] 29.794 [/TD]
[TD="class: xl111"] 24.422 [/TD]
[TD="class: xl111"] 29.794 [/TD]
[TD="class: xl111"] 39.075 [/TD]
[TD="class: xl111"] 31.260 [/TD]
[TD="class: xl111"] 37.121 [/TD]
[TD="class: xl111"] 39.075 [/TD]
[TD="class: xl111"] 32.237 [/TD]
[TD="class: xl111"] 42.494 [/TD]
[TD="class: xl111"] 24.422 [/TD]
[TD="class: xl111"] 22.956 [/TD]
[TD="class: xl111"] 27.352 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 380.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE5[/TD]
[TD="class: xl111"] 20.916 [/TD]
[TD="class: xl111"] 9.296 [/TD]
[TD="class: xl111"] 9.296 [/TD]
[TD="class: xl111"] 57.636 [/TD]
[TD="class: xl111"] 46.481 [/TD]
[TD="class: xl111"] 65.073 [/TD]
[TD="class: xl111"] 37.185 [/TD]
[TD="class: xl111"] 18.592 [/TD]
[TD="class: xl111"] 27.888 [/TD]
[TD="class: xl111"] 25.100 [/TD]
[TD="class: xl111"] 13.944 [/TD]
[TD="class: xl111"] 18.592 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 350.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE6[/TD]
[TD="class: xl111"] 41.342 [/TD]
[TD="class: xl111"] 53.745 [/TD]
[TD="class: xl111"] 77.517 [/TD]
[TD="class: xl111"] 82.685 [/TD]
[TD="class: xl111"] 70.282 [/TD]
[TD="class: xl111"] 72.349 [/TD]
[TD="class: xl111"] 87.852 [/TD]
[TD="class: xl111"] 87.852 [/TD]
[TD="class: xl111"] 64.081 [/TD]
[TD="class: xl111"] 46.510 [/TD]
[TD="class: xl111"] 36.174 [/TD]
[TD="class: xl111"] 49.611 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 770.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE7[/TD]
[TD="class: xl111"] 61.271 [/TD]
[TD="class: xl111"] 49.527 [/TD]
[TD="class: xl111"] 44.421 [/TD]
[TD="class: xl111"] 56.675 [/TD]
[TD="class: xl111"] 56.165 [/TD]
[TD="class: xl111"] 55.144 [/TD]
[TD="class: xl111"] 73.525 [/TD]
[TD="class: xl111"] 45.953 [/TD]
[TD="class: xl111"] 51.059 [/TD]
[TD="class: xl111"] 43.400 [/TD]
[TD="class: xl111"] 40.847 [/TD]
[TD="class: xl111"] 97.012 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 675.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE8[/TD]
[TD="class: xl111"] 35.019 [/TD]
[TD="class: xl111"] 40.169 [/TD]
[TD="class: xl111"] 55.618 [/TD]
[TD="class: xl111"] 72.097 [/TD]
[TD="class: xl111"] 69.007 [/TD]
[TD="class: xl111"] 59.738 [/TD]
[TD="class: xl111"] 53.558 [/TD]
[TD="class: xl111"] 51.498 [/TD]
[TD="class: xl111"] 32.959 [/TD]
[TD="class: xl111"] 28.839 [/TD]
[TD="class: xl111"] 25.749 [/TD]
[TD="class: xl111"] 25.749 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 550.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE9[/TD]
[TD="class: xl111"] 35.578 [/TD]
[TD="class: xl111"] 35.578 [/TD]
[TD="class: xl111"] 33.545 [/TD]
[TD="class: xl111"] 40.661 [/TD]
[TD="class: xl111"] 40.661 [/TD]
[TD="class: xl111"] 38.628 [/TD]
[TD="class: xl111"] 46.760 [/TD]
[TD="class: xl111"] 22.872 [/TD]
[TD="class: xl111"] 30.496 [/TD]
[TD="class: xl111"] 25.413 [/TD]
[TD="class: xl111"] 17.281 [/TD]
[TD="class: xl111"] 32.529 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 400.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE10[/TD]
[TD="class: xl111"] 69.314 [/TD]
[TD="class: xl111"] 79.216 [/TD]
[TD="class: xl111"] 84.167 [/TD]
[TD="class: xl111"] 84.167 [/TD]
[TD="class: xl111"] 97.039 [/TD]
[TD="class: xl111"] 95.059 [/TD]
[TD="class: xl111"] 103.971 [/TD]
[TD="class: xl111"] 59.412 [/TD]
[TD="class: xl111"] 84.167 [/TD]
[TD="class: xl111"] 75.255 [/TD]
[TD="class: xl111"] 79.216 [/TD]
[TD="class: xl111"] 99.020 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 1.010.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE11[/TD]
[TD="class: xl111"] 37.185 [/TD]
[TD="class: xl111"] 74.369 [/TD]
[TD="class: xl111"] 106.242 [/TD]
[TD="class: xl111"] 106.242 [/TD]
[TD="class: xl111"] 79.681 [/TD]
[TD="class: xl111"] 79.681 [/TD]
[TD="class: xl111"] 82.869 [/TD]
[TD="class: xl111"] 63.745 [/TD]
[TD="class: xl111"] 53.121 [/TD]
[TD="class: xl111"] 42.497 [/TD]
[TD="class: xl111"] 31.873 [/TD]
[TD="class: xl111"] 42.497 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 800.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE12[/TD]
[TD="class: xl111"] 41.578 [/TD]
[TD="class: xl111"] 21.088 [/TD]
[TD="class: xl111"] 23.043 [/TD]
[TD="class: xl111"] 27.186 [/TD]
[TD="class: xl111"] 29.060 [/TD]
[TD="class: xl111"] 28.128 [/TD]
[TD="class: xl111"] 29.509 [/TD]
[TD="class: xl111"] 18.699 [/TD]
[TD="class: xl111"] 21.608 [/TD]
[TD="class: xl111"] 33.853 [/TD]
[TD="class: xl111"] 38.054 [/TD]
[TD="class: xl111"] 38.194 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 350.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE13[/TD]
[TD="class: xl111"] 158.237 [/TD]
[TD="class: xl111"] 124.612 [/TD]
[TD="class: xl111"] 123.623 [/TD]
[TD="class: xl111"] 113.733 [/TD]
[TD="class: xl111"] 133.513 [/TD]
[TD="class: xl111"] 134.502 [/TD]
[TD="class: xl111"] 148.347 [/TD]
[TD="class: xl111"] 93.953 [/TD]
[TD="class: xl111"] 118.678 [/TD]
[TD="class: xl111"] 103.843 [/TD]
[TD="class: xl111"] 133.513 [/TD]
[TD="class: xl111"] 193.447 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 1.580.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE14[/TD]
[TD="class: xl111"] 26.425 [/TD]
[TD="class: xl111"] 31.314 [/TD]
[TD="class: xl111"] 36.335 [/TD]
[TD="class: xl111"] 62.629 [/TD]
[TD="class: xl111"] 46.971 [/TD]
[TD="class: xl111"] 52.191 [/TD]
[TD="class: xl111"] 60.466 [/TD]
[TD="class: xl111"] 42.408 [/TD]
[TD="class: xl111"] 19.540 [/TD]
[TD="class: xl111"] 20.040 [/TD]
[TD="class: xl111"] 21.949 [/TD]
[TD="class: xl111"] 29.732 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 450.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE15[/TD]
[TD="class: xl111"] 23.641 [/TD]
[TD="class: xl111"] 28.650 [/TD]
[TD="class: xl111"] 39.589 [/TD]
[TD="class: xl111"] 58.342 [/TD]
[TD="class: xl111"] 41.673 [/TD]
[TD="class: xl111"] 52.091 [/TD]
[TD="class: xl111"] 54.038 [/TD]
[TD="class: xl111"] 38.487 [/TD]
[TD="class: xl111"] 27.087 [/TD]
[TD="class: xl111"] 20.874 [/TD]
[TD="class: xl111"] 10.977 [/TD]
[TD="class: xl111"] 19.552 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 415.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE16[/TD]
[TD="class: xl111"] 22.512 [/TD]
[TD="class: xl111"] 20.465 [/TD]
[TD="class: xl111"] 25.581 [/TD]
[TD="class: xl111"] 26.605 [/TD]
[TD="class: xl111"] 26.605 [/TD]
[TD="class: xl111"] 28.651 [/TD]
[TD="class: xl111"] 22.000 [/TD]
[TD="class: xl111"] 26.605 [/TD]
[TD="class: xl111"] 28.140 [/TD]
[TD="class: xl111"] 27.116 [/TD]
[TD="class: xl111"] 20.465 [/TD]
[TD="class: xl111"] 33.256 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 308.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE17[/TD]
[TD="class: xl111"] 30.108 [/TD]
[TD="class: xl111"] 43.156 [/TD]
[TD="class: xl111"] 72.260 [/TD]
[TD="class: xl111"] 80.289 [/TD]
[TD="class: xl111"] 72.260 [/TD]
[TD="class: xl111"] 60.217 [/TD]
[TD="class: xl111"] 65.235 [/TD]
[TD="class: xl111"] 42.152 [/TD]
[TD="class: xl111"] 22.581 [/TD]
[TD="class: xl111"] 18.567 [/TD]
[TD="class: xl111"] 18.065 [/TD]
[TD="class: xl111"] 30.108 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 555.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE18[/TD]
[TD="class: xl111"] 125.305 [/TD]
[TD="class: xl111"] 69.614 [/TD]
[TD="class: xl111"] 83.537 [/TD]
[TD="class: xl111"] 83.537 [/TD]
[TD="class: xl111"] 74.255 [/TD]
[TD="class: xl111"] 64.973 [/TD]
[TD="class: xl111"] 65.020 [/TD]
[TD="class: xl111"] 52.907 [/TD]
[TD="class: xl111"] 54.299 [/TD]
[TD="class: xl111"] 91.890 [/TD]
[TD="class: xl111"] 114.167 [/TD]
[TD="class: xl111"] 140.496 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 1.020.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE19[/TD]
[TD="class: xl111"] 152.059 [/TD]
[TD="class: xl111"] 161.870 [/TD]
[TD="class: xl111"] 152.059 [/TD]
[TD="class: xl111"] 158.927 [/TD]
[TD="class: xl111"] 132.439 [/TD]
[TD="class: xl111"] 142.249 [/TD]
[TD="class: xl111"] 147.154 [/TD]
[TD="class: xl111"] 98.103 [/TD]
[TD="class: xl111"] 107.913 [/TD]
[TD="class: xl111"] 78.482 [/TD]
[TD="class: xl111"] 83.387 [/TD]
[TD="class: xl111"] 188.357 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 1.603.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE20[/TD]
[TD="class: xl111"] 22.567 [/TD]
[TD="class: xl111"] 29.077 [/TD]
[TD="class: xl111"] 47.738 [/TD]
[TD="class: xl111"] 49.474 [/TD]
[TD="class: xl111"] 59.021 [/TD]
[TD="class: xl111"] 56.417 [/TD]
[TD="class: xl111"] 56.417 [/TD]
[TD="class: xl111"] 39.926 [/TD]
[TD="class: xl111"] 36.454 [/TD]
[TD="class: xl111"] 26.039 [/TD]
[TD="class: xl111"] 20.831 [/TD]
[TD="class: xl111"] 26.039 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 470.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE21[/TD]
[TD="class: xl111"] 22.192 [/TD]
[TD="class: xl111"] 12.664 [/TD]
[TD="class: xl111"] 22.639 [/TD]
[TD="class: xl111"] 38.841 [/TD]
[TD="class: xl111"] 25.946 [/TD]
[TD="class: xl111"] 23.859 [/TD]
[TD="class: xl111"] 23.955 [/TD]
[TD="class: xl111"] 22.213 [/TD]
[TD="class: xl111"] 19.174 [/TD]
[TD="class: xl111"] 18.001 [/TD]
[TD="class: xl111"] 12.774 [/TD]
[TD="class: xl111"] 17.742 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 260.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE22[/TD]
[TD="class: xl111"] 67.228 [/TD]
[TD="class: xl111"] 58.825 [/TD]
[TD="class: xl111"] 88.237 [/TD]
[TD="class: xl111"] 88.237 [/TD]
[TD="class: xl111"] 88.237 [/TD]
[TD="class: xl111"] 88.237 [/TD]
[TD="class: xl111"] 92.439 [/TD]
[TD="class: xl111"] 92.439 [/TD]
[TD="class: xl111"] 67.228 [/TD]
[TD="class: xl111"] 63.561 [/TD]
[TD="class: xl111"] 97.460 [/TD]
[TD="class: xl111"] 76.273 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 968.400 [/TD]
[/TR]
[TR]
[TD="class: xl112"]STORE23[/TD]
[TD="class: xl111"] 109.050 [/TD]
[TD="class: xl111"] 95.816 [/TD]
[TD="class: xl111"] 97.450 [/TD]
[TD="class: xl111"] 128.102 [/TD]
[TD="class: xl111"] 99.038 [/TD]
[TD="class: xl111"] 123.419 [/TD]
[TD="class: xl111"] 100.286 [/TD]
[TD="class: xl111"] 110.706 [/TD]
[TD="class: xl111"] 101.415 [/TD]
[TD="class: xl111"] 116.221 [/TD]
[TD="class: xl111"] 120.870 [/TD]
[TD="class: xl111"] 97.626 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 1.300.000 [/TD]
[/TR]
[TR]
[TD="class: xl112"][/TD]
[TD="class: xl110"] 1.271.546 [/TD]
[TD="class: xl110"] 1.169.433 [/TD]
[TD="class: xl110"] 1.396.519 [/TD]
[TD="class: xl110"] 1.636.299 [/TD]
[TD="class: xl110"] 1.481.861 [/TD]
[TD="class: xl110"] 1.506.678 [/TD]
[TD="class: xl110"] 1.544.781 [/TD]
[TD="class: xl110"] 1.160.703 [/TD]
[TD="class: xl110"] 1.121.458 [/TD]
[TD="class: xl110"] 1.016.411 [/TD]
[TD="class: xl110"] 1.041.391 [/TD]
[TD="class: xl110"] 1.419.319 [/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: center"] 15.766.400 [/TD]
[/TR]
[TR]
[TD="class: xl107"]NEW VALUE[/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.265.151 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.135.843 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.360.899 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.659.384 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.495.843 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.511.887 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.429.416 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.152.286 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.171.042 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 983.650 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.122.000 [/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "] 1.479.000 [/TD]
[TD="class: xl115, align: center"][/TD]
[/TR]
</tbody>[/TABLE]

Michael M · Nov 9, 2018

Don't see anything in Blue but , how do you arrive at the new value AND have you tried using a Pivot table ??

Spread & rollup

p748r

New Member

Excel Facts

Michael M

Well-known Member

Forum statistics

Share this page

Spread & rollup

p748r

New Member

Excel Facts

Michael M

Well-known Member

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock