Spreadsheet: 90206d1289957011-posting-a-formula-repeatedly-after-x-columns-after
Sheet: After

MKC UN Equity |  |  |  |  | MMC UN Equity |  |  |  |  | MMM UN Equity |  |  |  |  | MO UN Equity
Date | PX_LAST | EQY_DPS |  |  | Date | PX_LAST | EQY_DPS |  |  | Date | PX_LAST | EQY_DPS |  |  | Date | PX_LAST | EQY_DPS
36556 | 13.2188 | 0.085 |  |  | 36556 | 47 | 0.225 |  |  | 36556 | 46.8125 | 0.28 |  |  | 36556 | 4.8462 | 0.48
36585 | 13.6875 | 0.095 |  |  | 36585 | 38.6875 | 0.225 |  |  | 36585 | 44.0625 | 0.28 |  |  | 36585 | 4.6437 | 0.48
36616 | 16.125 | 0.095 |  |  | 36616 | 55.1563 | 0.225 |  |  | 36616 | 44.2813 | 0.29 |  |  | 36616 | 4.8896 | 0.48
36644 | 15.5938 | 0.095 |  |  | 36644 | 49.2813 | 0.225 |  |  | 36644 | 43.25 | 0.29 |  |  | 36644 | 5.0632 | 0.48
36677 | 16.25 | 0.095 |  |  | 36677 | 55.0313 | 0.225 |  |  | 36677 | 42.875 | 0.29 |  |  | 36677 | 6.0469 | 0.48
36707 | 16.25 | 0.095 |  |  | 36707 | 52.2188 | 0.25 |  |  | 36707 | 41.25 | 0.29 |  |  | 36707 | 6.1481 | 0.48
36738 | 14.6563 | 0.095 |  |  | 36738 | 61 | 0.25 |  |  | 36738 | 45.0313 | 0.29 |  |  | 36738 | 5.8444 | 0.48
36769 | 14.5938 | 0.095 |  |  | 36769 | 59.375 | 0.25 |  |  | 36769 | 46.5 | 0.29 |  |  | 36769 | 6.857 | 0.48
36798 | 14.875 | 0.095 |  |  | 36798 | 66.375 | 0.25 |  |  | 36798 | 45.5625 | 0.29 |  |  | 36798 | 6.8136 | 0.53
36830 | 15.8438 | 0.095 |  |  | 36830 | 65.375 | 0.25 |  |  | 36830 | 48.3125 | 0.29 |  |  | 36830 | 8.4772 | 0.53
36860 | 18.625 | 0.095 |  |  | 36860 | 57.5625 | 0.25 |  |  | 36860 | 49.9375 | 0.29 |  |  | 36860 | 8.8389 | 0.53
36889 | 18.0313 | 0.095 |  |  | 36889 | 58.5 | 0.25 |  |  | 36889 | 60.25 | 0.29 |  |  | 36889 | 10.1842 | 0.53
36922 | 18.225 | 0.095 |  |  | 36922 | 54.075 | 0.25 |  |  | 36922 | 55.325 | 0.29 |  |  | 36922 | 10.1842 | 0.53
36950 | 19.65 | 0.1 |  |  | 36950 | 53.5 | 0.25 |  |  | 36950 | 56.375 | 0.29 |  |  | 36950 | 11.1517 | 0.53
36980 | 20.995 | 0.1 |  |  | 36980 | 47.515 | 0.25 |  |  | 36980 | 51.95 | 0.3 |  |  | 36980 | 10.9828 | 0.53
37011 | 19.65 | 0.1 |  |  | 37011 | 48.22 | 0.25 |  |  | 37011 | 59.505 | 0.3 |  |  | 37011 | 11.5984 | 0.53
37042 | 20.2 | 0.1 |  |  | 37042 | 52.45 | 0.25 |  |  | 37042 | 59.29 | 0.3 |  |  | 37042 | 11.8993 | 0.53
37071 | 21.01 | 0.1 |  |  | 37071 | 50.5 | 0.265 |  |  | 37071 | 57.05 | 0.3 |  |  | 37071 | 11.7466 | 0.53
37103 | 21.345 | 0.1 |  |  | 37103 | 50.2 | 0.265 |  |  | 37103 | 55.94 | 0.3 |  |  | 37103 | 10.5314 | 0.53
37134 | 22.6 | 0.1 |  |  | 37134 | 46.45 | 0.265 |  |  | 37134 | 52.05 | 0.3 |  |  | 37134 | 10.9712 | 0.53
37162 | 22.9 | 0.1 |  |  | 37162 | 48.35 | 0.265 |  |  | 37162 | 49.2 | 0.3 |  |  | 37162 | 11.1772 | 0.58
37195 | 21.88 | 0.1 |  |  | 37195 | 48.375 | 0.265 |  |  | 37195 | 52.19 | 0.3 |  |  | 37195 | 10.8323 | 0.58
37225 | 21.5 | 0.1 |  |  | 37225 | 53.485 | 0.265 |  |  | 37225 | 57.29 | 0.3 |  |  | 37225 | 10.9179 | 0.58
37256 | 20.985 | 0.1 |  |  | 37256 | 53.725 | 0.265 |  |  | 37256 | 59.105 | 0.3 |  |  | 37256 | 10.6124 | 0.58
37287 | 22.1 | 0.1 |  |  | 37287 | 50.925 | 0.265 |  |  | 37287 | 55.4 | 0.3 |  |  | 37287 | 11.5984 | 0.58
37315 | 24.5 | 0.105 |  |  | 37315 | 52.775 | 0.265 |  |  | 37315 | 58.965 | 0.3 |  |  | 37315 | 12.1887 | 0.58
37344 | 25.565 | 0.105 |  |  | 37344 | 56.37 | 0.265 |  |  | 37344 | 57.505 | 0.31 |  |  | 37344 | 12.191 | 0.58
37376 | 25.64 | 0.105 |  |  | 37376 | 50.54 | 0.265 |  |  | 37376 | 62.9 | 0.31 |  |  | 37376 | 12.5983 | 0.58
37407 | 26.26 | 0.105 |  |  | 37407 | 50.45 | 0.265 |  |  | 37407 | 62.715 | 0.31 |  |  | 37407 | 13.2511 | 0.58
37435 | 25.75 | 0.105 |  |  | 37435 | 48.3 | 0.28 |  |  | 37435 | 61.5 | 0.31 |  |  | 37435 | 10.1102 | 0.58
37468 | 22.75 | 0.105 |  |  | 37468 | 47.9 | 0.28 |  |  | 37468 | 62.915 | 0.31 |  |  | 37468 | 10.6587 | 0.58
37498 | 23.15 | 0.105 |  |  | 37498 | 48.65 | 0.28 |  |  | 37498 | 62.475 | 0.31 |  |  | 37498 | 11.573 | 0.58
37529 | 22.8 | 0.105 |  |  | 37529 | 41.64 | 0.28 |  |  | 37529 | 54.985 | 0.31 |  |  | 37529 | 8.9806 | 0.64
37560 | 22.24 | 0.105 |  |  | 37560 | 46.71 | 0.28 |  |  | 37560 | 63.47 | 0.31 |  |  | 37560 | 9.432 | 0.64
37589 | 23.79 | 0.105 |  |  | 37589 | 47.2 | 0.28 |  |  | 37589 | 64.925 | 0.31 |  |  | 37589 | 8.7307 | 0.64
37621 | 23.2 | 0.105 |  |  | 37621 | 46.21 | 0.28 |  |  | 37621 | 61.65 | 0.31 |  |  | 37621 | 9.3811 | 0.64
37652 | 22.4 | 0.105 |  |  | 37652 | 42.63 | 0.28 |  |  | 37652 | 62.275 | 0.31 |  |  | 37652 | 8.7654 | 0.64
37680 | 23.13 | 0.11 |  |  | 37680 | 40.7 | 0.28 |  |  | 37680 | 62.685 | 0.31 |  |  | 37680 | 8.9459 | 0.64
37711 | 24.14 | 0.11 |  |  | 37711 | 42.63 | 0.28 |  |  | 37711 | 65.015 | 0.33 |  |  | 37711 | 6.9345 | 0.64
37741 | 24.79 | 0.11 |  |  | 37741 | 47.68 | 0.28 |  |  | 37741 | 63.02 | 0.33 |  |  | 37741 | 7.1197 | 0.64
37771 | 26.9 | 0.11 |  |  | 37771 | 50.13 | 0.28 |  |  | 37771 | 63.235 | 0.33 |  |  | 37771 | 9.5593 | 0.64
37802 | 27.2 | 0.11 |  |  | 37802 | 51.07 | 0.31 |  |  | 37802 | 64.49 | 0.33 |  |  | 37802 | 10.5175 | 0.64
37833 | 25.56 | 0.11 |  |  | 37833 | 49.62 | 0.31 |  |  | 37833 | 70.1 | 0.33 |  |  | 37833 | 9.2607 | 0.64
37862 | 26.7 | 0.12 |  |  | 37862 | 50 | 0.31 |  |  | 37862 | 71.235 | 0.33 |  |  | 37862 | 9.5408 | 0.64
37894 | 27.42 | 0.12 |  |  | 37894 | 47.61 | 0.31 |  |  | 37894 | 69.07 | 0.33 |  |  | 37894 | 10.1379 | 0.68
37925 | 29.64 | 0.12 |  |  | 37925 | 42.75 | 0.31 |  |  | 37925 | 78.87 | 0.33 |  |  | 37925 | 10.7629 | 0.68
37953 | 28.69 | 0.12 |  |  | 37953 | 44.44 | 0.31 |  |  | 37953 | 79.04 | 0.33 |  |  | 37953 | 12.0359 | 0.68
37986 | 30.1 | 0.12 |  |  | 37986 | 47.89 | 0.31 |  |  | 37986 | 85.03 | 0.33 |  |  | 37986 | 12.596 | 0.68
38016 | 29.68 | 0.12 |  |  | 38016 | 46.93 | 0.31 |  |  | 38016 | 79.09 | 0.33 |  |  | 38016 | 12.8668 | 0.68
38044 | 31.27 | 0.14 |  |  | 38044 | 47.99 | 0.31 |  |  | 38044 | 78.02 | 0.33 |  |  | 38044 | 13.3205 | 0.68
38077 | 33.52 | 0.14 |  |  | 38077 | 46.3 | 0.31 |  |  | 38077 | 81.87 | 0.36 |  |  | 38077 | 12.603 | 0.68
38107 | 34.16 | 0.14 |  |  | 38107 | 45.1 | 0.31 |  |  | 38107 | 86.48 | 0.36 |  |  | 38107 | 12.8182 | 0.68
38138 | 35.45 | 0.14 |  |  | 38138 | 44.12 | 0.31 |  |  | 38138 | 84.56 | 0.36 |  |  | 38138 | 11.1031 | 0.68
38168 | 34 | 0.14 |  |  | 38168 | 45.38 | 0.34 |  |  | 38168 | 90.01 | 0.36 |  |  | 38168 | 11.5845 | 0.68
38198 | 35.77 | 0.14 |  |  | 38198 | 44.38 | 0.34 |  |  | 38198 | 82.36 | 0.36 |  |  | 38198 | 11.0175 | 0.68
38230 | 33.55 | 0.14 |  |  | 38230 | 44.69 | 0.34 |  |  | 38230 | 82.36 | 0.36 |  |  | 38230 | 11.3299 | 0.68
38260 | 34.34 | 0.14 |  |  | 38260 | 45.76 | 0.34 |  |  | 38260 | 79.97 | 0.36 |  |  | 38260 | 10.8879 | 0.73
38289 | 35.43 | 0.14 |  |  | 38289 | 27.66 | 0.34 |  |  | 38289 | 77.57 | 0.36 |  |  | 38289 | 11.2165 | 0.73
38321 | 36.45 | 0.14 |  |  | 38321 | 28.59 | 0.34 |  |  | 38321 | 79.59 | 0.36 |  |  | 38321 | 13.3066 | 0.73
38352 | 38.6 | 0.14 |  |  | 38352 | 32.9 | 0 |  |  | 38352 | 82.07 | 0.36 |  |  | 38352 | 14.1422 | 0.73
38383 | 37.17 | 0.14 |  |  | 38383 | 32.5 | 0 |  |  | 38383 | 84.36 | 0.36 |  |  | 38383 | 14.7741 | 0.73
38411 | 37.99 | 0.16 |  |  | 38411 | 32.65 | 0 |  |  | 38411 | 83.94 | 0.36 |  |  | 38411 | 15.1953 | 0.73
38442 | 34.43 | 0.16 |  |  | 38442 | 30.42 | 0.17 |  |  | 38442 | 85.69 | 0.42 |  |  | 38442 | 15.1351 | 0.73
38471 | 34.59 | 0.16 |  |  | 38471 | 28.03 | 0.17 |  |  | 38471 | 76.47 | 0.42 |  |  | 38471 | 15.0426 | 0.73
38503 | 33.84 | 0.16 |  |  | 38503 | 29.04 | 0.17 |  |  | 38503 | 76.65 | 0.42 |  |  | 38503 | 15.5402 | 0.73
38533 | 32.68 | 0.16 |  |  | 38533 | 27.7 | 0.17 |  |  | 38533 | 72.3 | 0.42 |  |  | 38533 | 14.9662 | 0.73
38562 | 34.78 | 0.16 |  |  | 38562 | 28.97 | 0.17 |  |  | 38562 | 75 | 0.42 |  |  | 38562 | 15.4985 | 0.73
38595 | 33.91 | 0.16 |  |  | 38595 | 28.05 | 0.17 |  |  | 38595 | 71.15 | 0.42 |  |  | 38595 | 16.3642 | 0.73
38625 | 32.63 | 0.16 |  |  | 38625 | 30.39 | 0.17 |  |  | 38625 | 73.36 | 0.42 |  |  | 38625 | 17.0609 | 0.8
38656 | 30.29 | 0.16 |  |  | 38656 | 29.15 | 0.17 |  |  | 38656 | 75.98 | 0.42 |  |  | 38656 | 17.371 | 0.8
38686 | 31.22 | 0.16 |  |  | 38686 | 30.89 | 0.17 |  |  | 38686 | 78.48 | 0.42 |  |  | 38686 | 16.8479 | 0.8
38716 | 30.92 | 0.16 |  |  | 38716 | 31.76 | 0.17 |  |  | 38716 | 77.5 | 0.42 |  |  | 38716 | 17.2947 | 0.8
38748 | 30.21 | 0.16 |  |  | 38748 | 30.39 | 0.17 |  |  | 38748 | 72.75 | 0.42 |  |  | 38748 | 16.7438 | 0.8
38776 | 32.83 | 0.18 |  |  | 38776 | 30.91 | 0.17 |  |  | 38776 | 73.59 | 0.42 |  |  | 38776 | 16.6419 | 0.8
38807 | 33.86 | 0.18 |  |  | 38807 | 29.36 | 0.17 |  |  | 38807 | 75.69 | 0.46 |  |  | 38807 | 16.4012 | 0.8
38835 | 34.83 | 0.18 |  |  | 38835 | 30.67 | 0.17 |  |  | 38835 | 85.43 | 0.46 |  |  | 38835 | 16.9336 | 0.8
38868 | 34.45 | 0.18 |  |  | 38868 | 28.03 | 0.17 |  |  | 38868 | 83.66 | 0.46 |  |  | 38868 | 16.7461 | 0.8
38898 | 33.55 | 0.18 |  |  | 38898 | 26.89 | 0.17 |  |  | 38898 | 80.77 | 0.46 |  |  | 38898 | 16.9961 | 0.8
38929 | 35.06 | 0.18 |  |  | 38929 | 27.03 | 0.17 |  |  | 38929 | 70.4 | 0.46 |  |  | 38929 | 18.5098 | 0.8
38960 | 36.42 | 0.18 |  |  | 38960 | 26.16 | 0.17 |  |  | 38960 | 71.7 | 0.46 |  |  | 38960 | 19.3338 | 0.8
38989 | 37.98 | 0.18 |  |  | 38989 | 28.15 | 0.17 |  |  | 38989 | 74.42 | 0.46 |  |  | 38989 | 17.7182 | 0.86
39021 | 37.4 | 0.18 |  |  | 39021 | 29.44 | 0.17 |  |  | 39021 | 78.84 | 0.46 |  |  | 39021 | 18.8246 | 0.86
39051 | 38.72 | 0.18 |  |  | 39051 | 31.42 | 0.17 |  |  | 39051 | 81.46 | 0.46 |  |  | 39051 | 19.4912 | 0.86
39080 | 38.56 | 0.18 |  |  | 39080 | 30.66 | 0.17 |  |  | 39080 | 77.93 | 0.46 |  |  | 39080 | 19.8639 | 0.86
39113 | 39.04 | 0.18 |  |  | 39113 | 29.5 | 0.17 |  |  | 39113 | 74.3 | 0.46 |  |  | 39113 | 20.2272 | 0.86
39141 | 38.29 | 0.2 |  |  | 39141 | 29.42 | 0.17 |  |  | 39141 | 74.08 | 0.46 |  |  | 39141 | 19.5074 | 0.86
39171 | 38.52 | 0.2 |  |  | 39171 | 29.29 | 0.19 |  |  | 39171 | 76.43 | 0.48 |  |  | 39171 | 20.3245 | 0.86
39202 | 37.12 | 0.2 |  |  | 39202 | 31.76 | 0.19 |  |  | 39202 | 82.77 | 0.48 |  |  | 39202 | 21.2557 | 0.86
39233 | 37.29 | 0.2 |  |  | 39233 | 32.83 | 0.19 |  |  | 39233 | 87.96 | 0.48 |  |  | 39233 | 21.928 | 0.86
39262 | 38.18 | 0.2 |  |  | 39262 | 30.88 | 0.19 |  |  | 39262 | 86.79 | 0.48 |  |  | 39262 | 21.632 | 0.69
39294 | 34.16 | 0.2 |  |  | 39294 | 27.55 | 0.19 |  |  | 39294 | 88.92 | 0.48 |  |  | 39294 | 20.5001 | 0.69
39325 | 35.84 | 0.2 |  |  | 39325 | 26.65 | 0.19 |  |  | 39325 | 90.99 | 0.48 |  |  | 39325 | 21.4068 | 0.69
39353 | 35.97 | 0.2 |  |  | 39353 | 25.5 | 0.19 |  |  | 39353 | 93.58 | 0.48 |  |  | 39353 | 21.4438 | 0.75
39386 | 35.03 | 0.2 |  |  | 39386 | 25.89 | 0.19 |  |  | 39386 | 86.36 | 0.48 |  |  | 39386 | 22.4924 | 0.75
39416 | 38.21 | 0.2 |  |  | 39416 | 25.12 | 0.19 |  |  | 39416 | 83.26 | 0.48 |  |  | 39416 | 23.9204 | 0.75
39447 | 37.91 | 0.2 |  |  | 39447 | 26.47 | 0.19 |  |  | 39447 | 84.32 | 0.48 |  |  | 39447 | 23.3097 | 0.75
39478 | 33.72 | 0.2 |  |  | 39478 | 27.6 | 0.19 |  |  | 39478 | 79.65 | 0.48 |  |  | 39478 | 23.3837 | 0.75
39507 | 34.45 | 0.22 |  |  | 39507 | 25.47 | 0.19 |  |  | 39507 | 78.4 | 0.48 |  |  | 39507 | 22.5572 | 0.75
39538 | 36.97 | 0.22 |  |  | 39538 | 24.35 | 0.4 |  |  | 39538 | 79.15 | 0.5 |  |  | 39538 | 22.2 | 0.75
39568 | 37.79 | 0.22 |  |  | 39568 | 27.59 | 0.4 |  |  | 39568 | 76.9 | 0.5 |  |  | 39568 | 20 | 0.75
39598 | 37.58 | 0.22 |  |  | 39598 | 27.23 | 0.4 |  |  | 39598 | 77.56 | 0.5 |  |  | 39598 | 22.26 | 0.75
39629 | 35.66 | 0.22 |  |  | 39629 | 26.55 | 0.2 |  |  | 39629 | 69.59 | 0.5 |  |  | 39629 | 20.56 | 0.29
39660 | 40.1 | 0.22 |  |  | 39660 | 28.25 | 0.2 |  |  | 39660 | 70.39 | 0.5 |  |  | 39660 | 20.35 | 0.29
39689 | 40.45 | 0.22 |  |  | 39689 | 31.93 | 0.2 |  |  | 39689 | 71.6 | 0.5 |  |  | 39689 | 21.03 | 0.29
39721 | 38.45 | 0.22 |  |  | 39721 | 31.76 | 0.2 |  |  | 39721 | 68.31 | 0.5 |  |  | 39721 | 19.84 | 0.32
39752 | 33.66 | 0.22 |  |  | 39752 | 29.32 | 0.2 |  |  | 39752 | 64.3 | 0.5 |  |  | 39752 | 19.19 | 0.32
39780 | 29.77 | 0.22 |  |  | 39780 | 25.5 | 0.2 |  |  | 39780 | 66.93 | 0.5 |  |  | 39780 | 16.08 | 0.32
39813 | 31.86 | 0.22 |  |  | 39813 | 24.27 | 0 |  |  | 39813 | 57.54 | 0.5 |  |  | 39813 | 15.06 | 0.32
39843 | 32.04 | 0.22 |  |  | 39843 | 19.33 | 0 |  |  | 39843 | 53.79 | 0.5 |  |  | 39843 | 16.54 | 0.32
39871 | 31.35 | 0.24 |  |  | 39871 | 17.93 | 0 |  |  | 39871 | 45.46 | 0.5 |  |  | 39871 | 15.44 | 0.32
39903 | 29.57 | 0.24 |  |  | 39903 | 20.25 | 0.4 |  |  | 39903 | 49.72 | 0.51 |  |  | 39903 | 16.02 | 0.32
39933 | 29.45 | 0.24 |  |  | 39933 | 21.09 | 0.4 |  |  | 39933 | 57.6 | 0.51 |  |  | 39933 | 16.33 | 0.32
39962 | 30.52 | 0.24 |  |  | 39962 | 18.92 | 0.4 |  |  | 39962 | 57.1 | 0.51 |  |  | 39962 | 17.09 | 0.32
39994 | 32.53 | 0.24 |  |  | 39994 | 20.13 | 0.4 |  |  | 39994 | 60.1 | 0.51 |  |  | 39994 | 16.39 | 0.32
40025 | 32.22 | 0.24 |  |  | 40025 | 20.42 | 0.4 |  |  | 40025 | 70.52 | 0.51 |  |  | 40025 | 17.53 | 0.32
40056 | 32.57 | 0.24 |  |  | 40056 | 23.54 | 0.4 |  |  | 40056 | 72.1 | 0.51 |  |  | 40056 | 18.28 | 0.32
40086 | 33.94 | 0.24 |  |  | 40086 | 24.73 | 0.2 |  |  | 40086 | 73.8 | 0.51 |  |  | 40086 | 17.81 | 0.34
40116 | 35.01 | 0.24 |  |  | 40116 | 23.46 | 0.2 |  |  | 40116 | 73.57 | 0.51 |  |  | 40116 | 18.11 | 0.34
40147 | 35.68 | 0.24 |  |  | 40147 | 22.55 | 0.2 |  |  | 40147 | 77.44 | 0.51 |  |  | 40147 | 18.81 | 0.34
40178 | 36.13 | 0.24 |  |  | 40178 | 22.08 | 0 |  |  | 40178 | 82.67 | 0.51 |  |  | 40178 | 19.63 | 0.34