Spreadsheet: 865924d1712875973-populating-rows-with-values-based-on-another-column-invoices-matching-with-receipts-muhammadziaurrehman-
Sheet: Sheet2

 |  |  | Receipt Date |  | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-06-28 00:00:00 | 2013-07-01 00:00:00 | 2013-07-02 00:00:00 | 2013-07-03 00:00:00 | 2013-07-05 00:00:00 | 2013-07-08 00:00:00 | 2013-07-10 00:00:00 | 2013-07-10 00:00:00 | 2013-07-16 00:00:00 | 2013-07-18 00:00:00 | 2013-07-22 00:00:00 | 2013-07-24 00:00:00 | 2013-07-25 00:00:00 | 2013-07-30 00:00:00 | 2013-07-30 00:00:00 | 2013-07-30 00:00:00 | 2013-07-30 00:00:00 | 2013-07-31 00:00:00 | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 | 2013-08-05 00:00:00 | 2013-08-07 00:00:00 | 2013-08-07 00:00:00 | 2013-08-15 00:00:00 | 2013-08-20 00:00:00 | 2013-08-20 00:00:00 | 2013-08-20 00:00:00 | 2013-08-22 00:00:00 | 2013-08-22 00:00:00 | 2013-08-22 00:00:00 | 2013-08-27 00:00:00 | 2013-08-27 00:00:00 | 2013-08-28 00:00:00 | 2013-08-28 00:00:00 | 2013-08-28 00:00:00 | 2013-08-29 00:00:00 | 2013-09-02 00:00:00 | 2013-09-02 00:00:00 | 2013-09-04 00:00:00 | 2013-09-04 00:00:00 | 2013-09-05 00:00:00 | 2013-09-09 00:00:00 | 2013-09-11 00:00:00 | 2013-09-16 00:00:00 | 2013-09-17 00:00:00 | 2013-09-20 00:00:00 | 2013-09-20 00:00:00 | 2013-09-24 00:00:00 | 2013-09-24 00:00:00 | 2013-09-24 00:00:00 | 2013-09-25 00:00:00 | 2013-09-26 00:00:00 | 2013-09-26 00:00:00 | 2013-09-26 00:00:00 | 2013-09-26 00:00:00 | 2013-09-27 00:00:00 | 2013-09-30 00:00:00 | 2013-10-02 00:00:00 | 2013-10-02 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-04 00:00:00 | 2013-10-04 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-10 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00 | 2013-10-23 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-25 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-03 00:00:00 | 2013-11-05 00:00:00 | 2013-11-05 00:00:00 | 2013-11-05 00:00:00 | 2013-11-05 00:00:00 | 2013-11-06 00:00:00 | 2013-11-06 00:00:00 | 2013-11-11 00:00:00 | 2013-11-11 00:00:00 | 2013-11-12 00:00:00 | 2013-11-13 00:00:00 | 2013-11-19 00:00:00 | 2013-11-20 00:00:00 | 2013-11-21 00:00:00 | 2013-11-22 00:00:00 | 2013-11-25 00:00:00 | 2013-11-26 00:00:00 | 2013-11-27 00:00:00 | 2013-11-28 00:00:00 | 2013-11-28 00:00:00 | 2013-11-29 00:00:00 | 2013-12-01 00:00:00 | 2013-12-03 00:00:00 | 2013-12-03 00:00:00 | 2013-12-03 00:00:00 | 2013-12-04 00:00:00 | 2013-12-05 00:00:00 | 2013-12-06 00:00:00 | 2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 2013-12-10 00:00:00 | 2013-12-11 00:00:00 | 2013-12-12 00:00:00 | 2013-12-16 00:00:00 | 2013-12-18 00:00:00 | 2013-12-19 00:00:00 | 2013-12-20 00:00:00 | 2013-12-24 00:00:00 | 2013-12-26 00:00:00 | 2013-12-27 00:00:00 | 2013-12-30 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00 | 2014-01-20 00:00:00 | 2014-01-22 00:00:00 | 2014-01-23 00:00:00 | 2014-01-24 00:00:00 | 2014-01-27 00:00:00 | 2014-01-28 00:00:00 | 2014-01-28 00:00:00 | 2014-01-29 00:00:00 | 2014-01-30 00:00:00 | 2014-01-31 00:00:00 | 2014-02-03 00:00:00 | 2014-02-04 00:00:00 | 2014-02-06 00:00:00 | 2014-02-10 00:00:00 | 2014-02-13 00:00:00 | 2014-02-17 00:00:00 | 2014-02-19 00:00:00 | 2014-02-20 00:00:00 | 2014-02-21 00:00:00 | 2014-02-26 00:00:00 | 2014-02-26 00:00:00 | 2014-02-27 00:00:00 | 2014-02-28 00:00:00 | 2014-03-03 00:00:00 | 2014-03-03 00:00:00 | 2014-03-03 00:00:00 | 2014-03-04 00:00:00 | 2014-03-05 00:00:00 | 2014-03-05 00:00:00 | 2014-03-06 00:00:00 | 2014-03-07 00:00:00 | 2014-03-10 00:00:00 | 2014-03-12 00:00:00 | 2014-03-13 00:00:00 | 2014-03-19 00:00:00 | 2014-03-21 00:00:00 | 2014-03-26 00:00:00 | 2014-03-27 00:00:00 | 2014-03-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-01 00:00:00 | 2014-04-01 00:00:00 | 2014-04-01 00:00:00 | 2014-04-02 00:00:00 | 2014-04-02 00:00:00 | 2014-04-03 00:00:00 | 2014-04-03 00:00:00 | 2014-04-04 00:00:00 | 2014-04-07 00:00:00 | 2014-04-22 00:00:00 | 2014-04-23 00:00:00 | 2014-04-24 00:00:00 | 2014-04-25 00:00:00 | 2014-04-29 00:00:00 | 2014-04-29 00:00:00 | 2014-04-29 00:00:00 | 2014-04-30 00:00:00 | 2014-04-30 00:00:00 | 2014-04-30 00:00:00 | 2014-04-30 00:00:00 | 2014-04-30 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | 2014-05-06 00:00:00 | 2014-05-06 00:00:00 | 2014-05-07 00:00:00 | 2014-05-07 00:00:00 | 2014-05-08 00:00:00 | 2014-05-14 00:00:00 | 2014-05-15 00:00:00 | 2014-05-21 00:00:00 | 2014-05-26 00:00:00 | 2014-05-27 00:00:00 | 2014-05-28 00:00:00 | 2014-05-28 00:00:00 | 2014-05-28 00:00:00 | 2014-06-02 00:00:00 | 2014-06-02 00:00:00 | 2014-06-02 00:00:00 | 2014-06-03 00:00:00 | 2014-06-03 00:00:00 | 2014-06-03 00:00:00 | 2014-06-04 00:00:00 | 2014-06-04 00:00:00 | 2014-06-05 00:00:00 | 2014-06-05 00:00:00 | 2014-06-06 00:00:00 | 2014-06-20 00:00:00 | 2014-06-20 00:00:00 | 2014-06-20 00:00:00 | 2014-06-21 00:00:00 | 2014-06-21 00:00:00 | 2014-06-24 00:00:00 | 2014-06-25 00:00:00 | 2014-06-25 00:00:00 | 2014-06-25 00:00:00 | 2014-06-26 00:00:00 | 2014-06-27 00:00:00 | 2014-07-02 00:00:00 | 2014-07-02 00:00:00 | 2014-07-02 00:00:00 | 2014-07-02 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-03 00:00:00 | 2014-07-03 00:00:00 | 2014-07-03 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-04 00:00:00 | 2014-07-07 00:00:00 | 2014-07-07 00:00:00 | 2014-07-16 00:00:00 | 2014-07-23 00:00:00 | 2014-07-23 00:00:00 | 2014-08-04 00:00:00 | 2014-08-05 00:00:00 | 2014-08-05 00:00:00 | 2014-08-06 00:00:00 | 2014-08-07 00:00:00 | 2014-08-08 00:00:00 | 2014-08-11 00:00:00 | 2014-08-11 00:00:00 | 2014-08-12 00:00:00 | 2014-08-15 00:00:00 | 2014-08-18 00:00:00 | 2014-08-18 00:00:00 | 2014-08-19 00:00:00 | 2014-08-21 00:00:00 | 2014-08-25 00:00:00 | 2014-08-28 00:00:00 | 2014-08-28 00:00:00 | 2014-08-28 00:00:00 | 2014-09-02 00:00:00 | 2014-09-02 00:00:00 | 2014-09-05 00:00:00 | 2014-09-05 00:00:00 | 2014-09-05 00:00:00 | 2014-09-05 00:00:00 | 2014-09-08 00:00:00 | 2014-09-08 00:00:00 | 2014-09-11 00:00:00 | 2014-09-12 00:00:00 | 2014-09-16 00:00:00 | 2014-09-17 00:00:00 | 2014-09-24 00:00:00 | 2014-09-25 00:00:00 | 2014-09-28 00:00:00 | 2014-09-28 00:00:00 | 2014-09-28 00:00:00 | 2014-09-28 00:00:00 | 2014-09-28 00:00:00 | 2014-09-28 00:00:00 | 2014-09-29 00:00:00 | 2014-10-13 00:00:00 | 2014-10-13 00:00:00 | 2014-10-13 00:00:00 | 2014-10-13 00:00:00 | 2014-10-13 00:00:00 | 2014-10-15 00:00:00 | 2014-10-20 00:00:00 | 2014-10-20 00:00:00 | 2014-10-21 00:00:00 | 2014-10-22 00:00:00 | 2014-10-22 00:00:00 | 2014-10-22 00:00:00 | 2014-10-22 00:00:00 | 2014-10-23 00:00:00 | 2014-10-27 00:00:00 | 2014-10-27 00:00:00 | 2014-10-28 00:00:00 | 2014-10-28 00:00:00 | 2014-10-29 00:00:00 | 2014-10-29 00:00:00 | 2014-10-30 00:00:00 | 2014-11-05 00:00:00 | 2014-11-06 00:00:00 | 2014-11-10 00:00:00 | 2014-11-10 00:00:00 | 2014-11-10 00:00:00 | 2014-11-11 00:00:00 | 2014-11-17 00:00:00 | 2014-11-17 00:00:00 | 2014-11-17 00:00:00 | 2014-11-17 00:00:00 | 2014-11-17 00:00:00 | 2014-11-19 00:00:00 | 2014-11-20 00:00:00 | 2014-11-24 00:00:00 | 2014-11-25 00:00:00 | 2014-11-26 00:00:00 | 2014-11-27 00:00:00 | 2014-11-27 00:00:00 | 2014-11-28 00:00:00 | 2014-12-02 00:00:00 | 2014-12-03 00:00:00 | 2014-12-03 00:00:00 | 2014-12-03 00:00:00 | 2014-12-08 00:00:00 | 2014-12-11 00:00:00 | 2014-12-11 00:00:00 | 2014-12-22 00:00:00 | 2014-12-22 00:00:00 | 2014-12-22 00:00:00 | 2014-12-23 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-01-14 00:00:00 | 2015-01-27 00:00:00 | 2015-01-27 00:00:00 | 2015-01-27 00:00:00
 |  |  | Receipt Amounts |  | 590922102 |  | 62457827 |  | 627193908.1020801 |  | 632313796.3537601 |  | 619941969.64092 |  | 660865457.3188 |  | 799995982 |  | 728097017 |  | 755658096.7957598 |  | 733026521.9152801 |  | 744249154.92984 | 592872499.6044 | 539128116 | 450473276.3433799 | 104399117.90566 | 307422182.6222 | 491558091.7870601 | 608993736.9985198 | 570256457.2315292 | 41000000 | 11057712.02234915 | 393921092.082 | 18611910.8 | 175169348.638144 | 249413390.28555 | 11784237.67 | 92054693.72198561 | 79594963.76847076 | 3405036.231529236 | 33000000 | 108000000 | 135000000 | 25000000 | 15000000 | 46000000 | 26000000 | 50000000 | 50000000 | 13000000 | 157554839.9634768 | 27779267.08335006 | 18321722.99 | 143123437.0465232 | 214000000 | 27912009.57697403 | 186087990.423026 | 215000000 | 43000000 | 64000000 | 22000000 | 19000000 | 21000000 | 39000000 | 58720403.18465 | 12601956.21 | 44677640.60535 | 10169075.60535 | 57830924.39465 | 78000000 | 6899252.07802403 | 12100747.92197597 | 165000000 | 137043459.8848841 | 87956540.11511594 | 158000000 | 93000000 | 93000000 | 93000000 | 56000000 | 28000000 | 88000000 | 36000000 | 36000000 | 47614031.69 | 17803732.43 | 6582235.880000003 | 69000000 | 56463951.35230404 | 335942948.64618 | 72187140.95308131 | 16405959.04843462 | 144000000 | 107000000 | 125000000 | 74407905.27156538 | 104592094.7284346 | 179000000 | 122665113.5681654 | 18805592.2 | 1529294.231834635 | 71000000 | 36000000 | 41000000 | 6555428.524867356 | 13444571.47513264 | 33000000 | 33000000 | 33000000 | 31000000 | 133000000 | 65000000 | 70000000 | 81638056.00886738 | 52361943.99113262 | 134000000 | 101000000 | 67000000 | 17331308.7667374 | 17205631.29 | 32463059.9432626 | 67000000 | 43342131.25692129 | 6657868.743078709 | 58000000 | 25000000 | 33000000 | 33000000 | 17000000 | 17000000 | 17000000 | 25000000 | 50000000 | 67000000 | 100000000 | 2473783.680721283 | 179526216.3192787 | 196000000 | 105000000 | 72492345.99606133 | 25599155.78 | 7908498.223938674 | 53000000 | 80000000 | 61000000 | 10562190.82604119 | 68437809.17395881 | 50000000 | 20000000 | 20000000 | 20000000 | 44000000 | 32000000 | 9000000 | 15000000 | 38000000 | 78000000 | 78000000 | 157000000 | 41772055.37764144 | 95227944.62235856 | 137000000 | 156000000 | 59000000 | 69863322.09976143 | 8136677.900238574 | 15799408.13976143 | 11200591.86023857 | 11000000 | 27000000 | 18000000 | 27000000 | 37000000 | 37000000 | 30466768.02401778 | 6533231.975982219 | 73000000 | 92000000 | 54000000 | 73000000 | 54000000 | 37000000 | 63000000 | 14000000 | 7000000 | 12000000 | 23000000 | 13000000 | 23000000 | 48000000 | 48000000 | 95000000 | 151453348.09144 | 24739774.48 | 111806877.42856 | 72000000 | 14468975.82426324 | 21531024.17573676 | 48000000 | 36000000 | 14000000 | 14000000 | 12000000 | 12000000 | 24000000 | 86000000 | 98000000 | 123000000 | 12000000 | 31697053.42000002 | 22393100.65 | 68909845.92999998 | 90980854.80905846 | 155019145.1909415 | 169621113.359496 | 52378886.640504 | 246000000 | 116000000 | 50000000 | 26000000 | 51000000 | 128000000 | 117654807.66 | 21426589.83 | 116918602.51 | 74528644 |  | 29777808 |  | 49693548 | 41614622 |  | 61385378 |  | 12709511 |  | 71875785 |  | 43414704 | 29561499 | 34438501 | 47651819.39691532 | 42348180.60308468 | 51000000 | 13000000 | 13000000 | 90000000 | 103000000 | 106000000 | 56603511.96569532 | 20825734.13 | 55570753.90430468 | 23694697 | 228502210 | 132803093 | 58123954.69999999 | 44248163.90000001 | 109627881.4 | 20668881.59999998 | 130331118.4 | 38967106 | 112032894 | 25000000 | 39042070.49999999 | 258113815.8 | 167844113.7 | 75929395.1 | 44070604.90000001 | 60000000 | 34144664 | 15651819.07962361 | 132424249.8403764 | 180000000 | 120000000 | 65802994.09999999 | 54197005.90000001 | 131922102.1 | 350298000.179496 | 118779897.7205039 | 28240728.25182366 | 20199288.44 | 201991069.064017 | 344286577.58 | 6282336.664159298 | 8813979.155840702 | 81186020.8441593 | 155224221.3125831 | 69775778.68741691 | 108000000 | 43000000 | 22000000 | 129000000 | 65000000 | 63000000 | 128000000 | 128000000 | 73000000 | 64331015.38999999 | 19668984.61000001 | 34000000 | 34000000 | 110204079.926913 | 57795920.07308698 | 25000000 | 85000000 | 66000000 | 25217865 | 3190395.139999986 | 70591739.86000001 | 128000000 | 98000000 | 35000000 | 63000000 | 95000000.29582247 | 2999999.704177529 | 16015212.22691303 | 81984787.77308697 | 33000000 | 16000000 | 16000000 | 16000000 | 84000000 | 84000000 | 99000000 | 30000000 | 157009651.8507825 | 5990348.149217486 | 19204447.09078252 | 57795552.90921748 | 84000000 | 23000000 | 87150131.95921093 | 20849868.04078907 | 46000000 | 123000000 | 74000000 | 45000000 | 174000000 | 25000000 | 24366756.95921093 | 24923509 | 709734.0407890677 | 15000000 | 50000000 | 50000000 | 50000000 | 41153152.95921093 | 68846847.04078907 | 98000000 | 165000000 | 75000000 | 269000000 | 147000000 | 23143939.52397996 | 20564949.87 | 103291110.60602 | 24000000 | 88643462.75150833 | 97000000 | 122000000 | 49000000 | 78356537.24849167 | 59000000 | 35000000 | 90000000 | 75000000 | 50000000 | 129077570.2077026 | 20922429.79229736 | 221000000 | 201000000 | 74104468.3339026 | 24212180.3 | 151683351.3660974 | 12000000 | 36000000 | 38000000 | 55563727.46232444 | 51000000 | 4436272.53767556 | 28000000 | 29931006.84999999 | 214265898.3 | 56000000 | 248448874.7845886 | 123331780.85 | 84925560.44999996 | 505325605.4078999 | 201992887 | 48150155.34 | 150963158.2 | 793329458 | 452242620.8 | 21178356.28 | 124785637.7400001 | 68000000 | 329514377.5289401 | 469891824.9710599 | 49000000
 | Month |  | [NAME]
1 | July 2012 | 2012-09-05 00:00:00 | 1484350358
 | August 2012 | 2012-10-05 00:00:00 | 1240262101.8592
 | September 2012 | 2012-11-05 00:00:00 | 287436072.6944
 | October 2012 | 2012-12-05 00:00:00 | 846407772.448
 | November 2012 | 2013-01-05 00:00:00 | 1353378555.6704
 | December 2012 | 2012-02-05 00:00:00 | 1676707347.4368
 | January 2013 | 2012-03-05 00:00:00 | 1663380737.410278
 | February 2013 | 2012-04-05 00:00:00 | 1392112089.562431
 | March 2013 | 2012-05-05 00:00:00 | 1269977777.626544
 | April 2013 | 2012-06-05 00:00:00 | 667396529.4843956
 | May 2013 | 2012-07-05 00:00:00 | 1037644918.587293
 | June 2013 | 2012-08-05 00:00:00 | 717773873.04083
 | July 2013 | 2012-09-05 00:00:00 | 1017001005.273081