Spreadsheet: 757095d1638014910-formula-to-copy-four-rows-value-into-four-columns-upto-certain-rows-demo
Sheet: Sheet1

 | BILL NO & DATE |  | 600 | 02.01.2021 |  |  |  |  | REF BILL NO:: | [PHONE]
 | [NAME] |  | 5800 | (IN NO'S) |  |  |  |  | DATE: | 12.10.2020
 | QTY |  | 2897.27 | (IN QTLS) |  |  |  |  | SEASON: | RABI-19-20
 | RATE |  |  | 3045.37 |  |  |  |  | VARIETY | BR GRADE A
[NAME] | SL NO | DELIVERY POINT | DEPOT CODE | MILL NAME | [NAME] | ACK NO | ACK DATE | TOTAL COST      (RS.) | WITH HOLD | QUALITY CUTS     (5244) | ROUND OFF (4216) | NETT PAID (RS.) | REF BILL NO | DATE | SEASON | VARIETY
[PHONE].xls | 1 | BSC KHMM | SF15999 | SRI VENKATESHWARA RI PVT. LTD | KHMM | 5105 | 08.10.2020 | 883157.30 | 81020.20 | 2207.89 | -0.21 | 799929.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 2 | BSC KHMM | SF15999 | PADMAVATHI VENKATESHWARA     PBRM | KHMM | 5106 | 08.10.2020 | 883157.30 | 81020.20 | 3091.05 | -0.05 | 799046.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 3 | BSC KHMM | SF15999 | SRI VENKATESHWARA RI PVT. LTD | KHMM | 5107 | 06.10.2020 | 883157.30 | 81020.20 | 3974.21 | 0.11 | 798163.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 4 | BSC KHMM | SF15999 | SRI VASUNDHARA RICE PRODUCTS PVT.LTD | KHMM | 5140 | 08.10.2020 | 881744.24 | 80890.56 | 3967.85 | 0.17 | 796886.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 5 | BSC KHMM | SF15999 | SRI VASUNDHARA RICE PRODUCTS PVT.LTD | KHMM | 5176 | 08.10.2020 | 883114.67 | 81016.29 | 3090.90 | -0.48 | 799007.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 6 | BSC KHMM | SF15999 | SRI VASUNDHARA RICE PRODUCTS PVT.LTD | KHMM | 5177 | 08.10.2020 | 882048.78 | 80918.50 | 2205.12 | -0.16 | 798925.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 7 | BSC KHMM | SF15999 | SRI VASUNDHARA RICE PRODUCTS PVT.LTD | KHMM | 5197 | 08.10.2020 | 881896.52 | 80904.54 | 3968.53 | -0.45 | 797023.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 8 | BSC KHMM | SF15999 | SRI DHANALAXMI PBRM | KHMM | 5214 | 08.10.2020 | 883157.30 | 81020.20 | 2207.89 | -0.21 | 799929.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 9 | BSC KHMM | SF15999 | SRI USHASWINI R I | KHMM | 5257 | 08.10.2020 | 882353.32 | 80946.44 | 0.00 | 0.12 | 801407.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls | 10 | BSC KHMM | SF15999 | SRI USHASWINI R I | KHMM | 5261 | 08.10.2020 | 879460.22 | 80681.04 | 1319.19 | 0.01 | 797460.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
[PHONE].xls |  |  |  |  | TOTAL |  |  | 8823246.95 | 809438.17 | 26032.64 | -1.14 | 7987775.00 | Value in K1 | Value in K2 | Value in K3 | Value in K4
 | BILL NO & DATE |  | 617 | 02.01.2021 |  |  |  |  | REF BILL NO:: | CMR1920531484
 | [NAME] |  | 5800 | (IN NO'S) |  |  |  |  | DATE: | 28.10.2020
 | QTY |  | 2894.94 | (IN QTLS) |  |  |  |  | SEASON: | RABI-19-20
 | RATE |  |  | 3045.37 |  |  |  |  | VARIETY | BR GRADE A
[NAME] | SL NO | DELIVERY POINT | DEPOT CODE | MILL NAME | [NAME] | ACK NO | ACK DATE | TOTAL COST      (RS.) | WITH HOLD | QUALITY CUTS     (5244) | ROUND OFF (4216) | NETT PAID (RS.) | REF BILL NO | DATE | SEASON | VARIETY
[PHONE].xls | 1 | BSC KHMM | SF15999 | SREE RAMACHANDRA PBMRM |  | 5491 | 16.10.2020 | 883157.30 | 81020.20 | 3091.05 | -0.05 | 799046.00 | Value in K17 | Value in K18 | Value in K19 | Value in K20
[PHONE].xls | 2 | BSC KHMM | SF15999 | SREE RAMACHANDRA PBMRM |  | 5518 | 17.10.2020 | 881896.52 | 80904.54 | 0.00 | 0.02 | 800992.00 | Value in K17 | Value in K18 | Value in K19 | Value in K20
[PHONE].xls | 3 | BSC KHMM | SF15999 | SRI MATHA SAI BALAJI RICE INDUSTRIES HUZURNAGAR |  | 5694 | 21.10.2020 | 881744.24 | 80890.56 | 3086.10 | 0.42 | 797768.00 | Value in K17 | Value in K18 | Value in K19 | Value in K20
[PHONE].xls | 4 | BSC KHMM | SF15999 | SRI SRINIVASA SAI SHIVAYA RICE INDUSTRIES |  | 5715 | 20.10.2020 | 882201.06 | 80932.48 | 6616.51 | -0.07 | 794652.00 | Value in K17 | Value in K18 | Value in K19 | Value in K20
[PHONE].xls |  |  |  |  | TOTAL |  |  | 8816157.34 | 808787.78 | 33060.64 | 0.08 | 7974309.00 | Value in K17 | Value in K18 | Value in K19 | Value in K20
 | BILL NO & DATE |  | 625 | 04.01.2021 |  |  |  |  | REF BILL NO:: | [PHONE]
 | [NAME] |  | 4640 | (IN NO'S) |  |  |  |  | DATE: | 31.12.2020
 | QTY |  | 2314.50 | (IN QTLS) |  |  |  |  | SEASON: | RABI 2019-20
 | RATE |  |  | 3045.37 |  |  |  |  | VARIETY | BR GRADE A
[NAME] | SL NO | DELIVERY POINT | DEPOT CODE | MILL NAME | [NAME] | ACK NO | ACK DATE | TOTAL COST      (RS.) | WITH HOLD | QUALITY CUTS     (5244) | ROUND OFF (4216) | NETT PAID (RS.) | REF BILL NO | DATE | SEASON | VARIETY
[NAME] | 1 | BSC FCI NALGONDA | SF15002 | ASR INDUSTRIES PARBOILED RICE MILL | THIRUMALAGIRI | 7382 | 01.12.2020 | 881939.16 | 80908.45 | 1852.07 | 0.36 | 799179.00 | Value in K27 | Value in K28 | Value in K29 | Value in K30
[NAME] | 2 | BSC FCI NALGONDA | SF15002 | ASR INDUSTRIES PARBOILED RICE MILL | THIRUMALAGIRI | 7383 | 01.12.2020 | 883157.30 | 81020.20 | 1854.63 | -0.47 | 800282.00 | Value in K27 | Value in K28 | Value in K29 | Value in K30
[NAME] |  |  |  |  | TOTAL |  |  | 7048508.87 | 646625.01 | 23522.19 | -0.67 | 6378361.00 | Value in K27 | Value in K28 | Value in K29 | Value in K30
 | BILL NO & DATE |  | 646 | 15.01.2021 |  |  |  |  | REF BILL NO:: | CMR [PHONE]
 | [NAME] |  | 5220 | (IN NO'S) |  |  |  |  | DATE: | 08.01.2021
 | QTY |  | 2606.60 | (IN QTLS) |  |  |  |  | SEASON: | RABI-19-20
 | RATE |  |  | 3045.37 |  |  |  |  | VARIETY | BR GRADE A
[NAME] | SL NO | DELIVERY POINT | DEPOT CODE | MILL NAME | [NAME] | ACK NO | ACK DATE | TOTAL COST      (RS.) | WITH HOLD | QUALITY CUTS     (5244) | ROUND OFF (4216) | NETT PAID (RS.) | REF BILL NO | DATE | SEASON | VARIETY
[PHONE].xls | 1 | BSC MLG | SF15001 | SRI VENKATESWARA RI PVT LTD |  | 7606 | 01.12.2020 | 882548.23 | 80964.33 | 7236.90 | -0.00 | 794347.00 | Value in K35 | Value in K36 | Value in K37 | Value in K38
[PHONE].xls |  |  |  |  | TOTAL |  |  | 7938061.47 | 728231.92 | 34048.94 | 0.39 | 7175781.00 | Value in K35 | Value in K36 | Value in K37 | Value in K38
 | BILL NO & DATE |  | 627 | 05.01.2020 |  |  |  |  | REF BILL NO:: | CMR [PHONE]
 | [NAME] |  | 5800 | (IN NO'S) |  |  |  |  | DATE: | 03.11.2020
 | QTY |  | 2893.91 | (IN QTLS) |  |  |  |  | SEASON: | RABI-19-20
 | RATE |  |  | 3045.37 |  |  |  |  | VARIETY | BR GRADE A
[NAME] | SL NO | DELIVERY POINT | DEPOT CODE | MILL NAME | [NAME] | ACK NO | ACK DATE | TOTAL COST      (RS.) | WITH HOLD | QUALITY CUTS     (5244) | ROUND OFF (4216) | NETT PAID (RS.) | REF BILL NO | DATE | SEASON | VARIETY
[PHONE].xls | 1 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5509 | 17.10.2020 | 880678.37 | 80792.78 | 1321.02 | 0.43 | 798565.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 2 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5596 | 20.10.2020 | 882201.06 | 80932.48 | 4852.11 | -0.47 | 796416.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 3 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5650 | 09.10.2020 | 880373.82 | 80764.84 | 3081.31 | 0.33 | 796528.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 4 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5697 | 20.10.2020 | 883114.67 | 81016.29 | 4857.13 | -0.25 | 797241.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 5 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5702 | 20.10.2020 | 883114.67 | 81016.29 | 8389.59 | 0.21 | 793709.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 6 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5703 | 20.10.2020 | 879460.22 | 80681.04 | 1319.19 | 0.01 | 797460.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 7 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5722 | 20.10.2020 | 881896.52 | 80904.54 | 3968.53 | -0.45 | 797023.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 8 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5754 | 21.10.2020 | 879155.69 | 80653.10 | 439.58 | -0.01 | 798063.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 9 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5778 | 21.10.2020 | 883114.67 | 81016.29 | 4857.13 | -0.25 | 797241.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls | 10 | BSC KHMM | SF15999 | SRI VENKATESWARA RI PVT LTD |  | 5799 | 22.10.2020 | 879917.01 | 80722.93 | 1319.88 | -0.20 | 797874.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
[PHONE].xls |  |  |  |  | TOTAL |  |  | 8813026.70 | 808500.58 | 34405.46 | -0.66 | 7970120.00 | Value in K42 | Value in K43 | Value in K44 | Value in K45
 | BILL NO & DATE |  | 623 | 04.01.2021 |  |  |  |  | REF BILL NO:: | [PHONE]
 | [NAME] |  | 5800 | (IN NO'S) |  |  |  |  | DATE: | 31.12.2020
 | QTY |  | 2893.00 | (IN QTLS) |  |  |  |  | SEASON: | RABI 2019-20
 | RATE |  |  | 3045.37 |  |  |  |  | VARIETY | BR GRADE A
[NAME] | SL NO | DELIVERY POINT | DEPOT CODE | MILL NAME | [NAME] | ACK NO | ACK DATE | TOTAL COST      (RS.) | WITH HOLD | QUALITY CUTS     (5244) | ROUND OFF (4216) | NETT PAID (RS.) | REF BILL NO | DATE | SEASON | VARIETY
[PHONE].xls | 1 | BSC FCI NALGONDA | SF15002 | ASR INDUSTRIES PARBOILED RICE MILL | THIRUMALAGIRI | 7332 | 28.11.2020 | 881330.07 | 80852.57 | 0.00 | 0.50 | 800478.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 2 | BSC FCI NALGONDA | SF15002 | ASR INDUSTRIES PARBOILED RICE MILL | THIRUMALAGIRI | 7384 | 16.12.2020 | 879198.31 | 80657.00 | 967.12 | -0.19 | 797574.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 3 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7561 | 19.12.2020 | 878893.79 | 80629.07 | 0.00 | 0.28 | 798265.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 4 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7565 | 16.12.2020 | 881330.07 | 80852.57 | 0.00 | 0.50 | 800478.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 5 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7613 | 18.12.2020 | 881634.62 | 80880.51 | 88.16 | 0.05 | 800666.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 6 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7614 | 23.12.2020 | 880721.00 | 80796.69 | 0.00 | -0.31 | 799924.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 7 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7615 | 18.12.2020 | 881634.62 | 80880.51 | 88.16 | 0.05 | 800666.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 8 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7616 | 22.12.2020 | 881939.16 | 80908.45 | 88.19 | 0.48 | 800943.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 9 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7637 | 22.12.2020 | 881939.16 | 80908.45 | 970.13 | 0.42 | 800061.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls | 10 | BSC FCI NALGONDA | SF15002 | SRI VASAVI RICE INDUSTRIES | THIRUMALAGIRI | 7638 | 19.12.2020 | 881634.62 | 80880.51 | 3614.70 | -0.41 | 797139.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
[PHONE].xls |  |  |  |  | TOTAL |  |  | 8810255.42 | 808246.33 | 5816.47 | 1.38 | 7996194.00 | Value in K58 | Value in K59 | Value in K60 | Value in K61
 | BILL NO & DATE |  | 645 | 15.01.2021 |  |  |  |  | REF BILL NO:: | CMR [PHONE]
 | [NAME] |  | 5800 | (IN NO'S) |  |  |  |  | DATE: | 08.01.2021
 | QTY |  | 2897.40 | (IN QTLS) |  |  |  |  | SEASON: | RABI-19-20
 | RATE |  |  | 3045.37 |  |  |  |  | VARIETY | BR GRADE A
[NAME] | SL NO | DELIVERY POINT | DEPOT CODE | MILL NAME | [NAME] | ACK NO | ACK DATE | TOTAL COST      (RS.) | WITH HOLD | QUALITY CUTS     (5244) | ROUND OFF (4216) | NETT PAID (RS.) | REF BILL NO | DATE | SEASON | VARIETY
[PHONE].xls | 1 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7481 | 19.11.2020 | 883157.30 | 81020.20 | 4592.42 | 0.32 | 797545.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 2 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7491 | 19.11.2020 | 880111.93 | 80740.82 | 1056.13 | 0.02 | 798315.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 3 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7518 | 21.11.2020 | 882548.23 | 80964.33 | 1059.06 | 0.16 | 800525.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 4 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7520 | 21.11.2020 | 882243.68 | 80936.38 | 0.00 | -0.30 | 801307.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 5 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7526 | 21.11.2020 | 883157.30 | 81020.20 | 0.00 | -0.10 | 802137.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 6 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7536 | 23.11.2020 | 882243.68 | 80936.38 | 176.45 | 0.15 | 801131.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 7 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7538 | 23.11.2020 | 883157.30 | 81020.20 | 0.00 | -0.10 | 802137.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 8 | BSC MLG | SF15001 | LAXMI SAHASRA RI MUKANDAPURAM |  | 7561 | 24.11.2020 | 882548.23 | 80964.33 | 176.51 | -0.39 | 801407.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 9 | BSC MLG | SF15001 | SRI VENKATESWARA RI PVT LTD |  | 7605 | 01.12.2020 | 883157.30 | 81020.20 | 6358.73 | -0.37 | 795778.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls | 10 | BSC MLG | SF15001 | GOUTHAMI PBI |  | 7717 | 11.12.2020 | 881330.07 | 80852.57 | 0.00 | 0.50 | 800478.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78
[PHONE].xls |  |  |  |  | TOTAL |  |  | 8823655.02 | 809475.61 | 13419.30 | -0.11 | 8000760.00 | Value in K74 | Value in K75 | Value in K76 | Value in K78