Divide Value of a Cell not to exceed 999 and Copy other Row info down

L

lslau

New Member
Joined
Apr 11, 2018
Messages
1
I have this sample data:
[TABLE="class: xl714523, width: 740"]
<tbody>[TR]
[/TR]
[TR="class: xl694523"]
[TD="class: xl674523"]AcctNo[/TD]
[TD="class: xl674523"] Name[/TD]
[TD="class: xl674523"]ReferDate[/TD]
[TD="class: xl674523"]DocNo[/TD]
[TD="class: xl674523"]PatientID[/TD]
[TD="class: xl684523, align: right"]units[/TD]
[TD="class: xl684523, align: right"]num[/TD]
[TD="class: xl674523"]Code[/TD]
[TD="class: xl724523"]Service[/TD]
[TD="class: xl724523"]Claim ID[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361004[/TD]
[TD="class: xl654523"]TEST1[/TD]
[TD="class: xl704523"]4/30/2013[/TD]
[TD="class: xl654523"]99[/TD]
[TD="class: xl654523"]1[/TD]
[TD="class: xl664523, align: right"]2099[/TD]
[TD="class: xl734523"] 2.1[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234568[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361005[/TD]
[TD="class: xl654523"]TEST2[/TD]
[TD="class: xl704523"]10/31/2014[/TD]
[TD="class: xl654523"]99[/TD]
[TD="class: xl654523"]2[/TD]
[TD="class: xl664523, align: right"]1636[/TD]
[TD="class: xl734523"] 1.6[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234569[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361006[/TD]
[TD="class: xl654523"]TEST3[/TD]
[TD="class: xl704523"]10/11/2013[/TD]
[TD="class: xl654523"]99[/TD]
[TD="class: xl654523"]3[/TD]
[TD="class: xl664523, align: right"]1135[/TD]
[TD="class: xl734523"] 1.1[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234570[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361007[/TD]
[TD="class: xl654523"]TEST4[/TD]
[TD="class: xl704523"]4/30/2013[/TD]
[TD="class: xl654523"]826[/TD]
[TD="class: xl654523"]4[/TD]
[TD="class: xl664523, align: right"]2548[/TD]
[TD="class: xl734523"] 2.6[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234571[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361008[/TD]
[TD="class: xl654523"]TEST5[/TD]
[TD="class: xl704523"]3/12/2015[/TD]
[TD="class: xl654523"]817[/TD]
[TD="class: xl654523"]5[/TD]
[TD="class: xl664523, align: right"]1478[/TD]
[TD="class: xl734523"] 1.5[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234572[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361009[/TD]
[TD="class: xl654523"]TEST6[/TD]
[TD="class: xl704523"]4/30/2013[/TD]
[TD="class: xl654523"]865[/TD]
[TD="class: xl654523"]6[/TD]
[TD="class: xl664523, align: right"]4869[/TD]
[TD="class: xl734523"] 4.9[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234573[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361010[/TD]
[TD="class: xl654523"]TEST7[/TD]
[TD="class: xl704523"]9/20/2013[/TD]
[TD="class: xl654523"]99[/TD]
[TD="class: xl654523"]7[/TD]
[TD="class: xl664523, align: right"]1058[/TD]
[TD="class: xl734523"] 1.1[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234574[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361011[/TD]
[TD="class: xl654523"]TEST8[/TD]
[TD="class: xl704523"]12/23/2016[/TD]
[TD="class: xl654523"]99[/TD]
[TD="class: xl654523"]8[/TD]
[TD="class: xl664523, align: right"]1265[/TD]
[TD="class: xl734523"] 1.3[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234575[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361012[/TD]
[TD="class: xl654523"]TEST9[/TD]
[TD="class: xl704523"]2/8/2013[/TD]
[TD="class: xl654523"]99[/TD]
[TD="class: xl654523"]9[/TD]
[TD="class: xl664523, align: right"]4586[/TD]
[TD="class: xl734523"] 4.6[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234576[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361013[/TD]
[TD="class: xl654523"]TEST10[/TD]
[TD="class: xl704523"]11/22/2013[/TD]
[TD="class: xl654523"]664[/TD]
[TD="class: xl654523"]10[/TD]
[TD="class: xl664523, align: right"]1658[/TD]
[TD="class: xl734523"] 1.7[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234577[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl654523"]361014[/TD]
[TD="class: xl654523"]TEST11[/TD]
[TD="class: xl704523"]3/12/2015[/TD]
[TD="class: xl654523"]99[/TD]
[TD="class: xl654523"]11[/TD]
[TD="class: xl664523, align: right"]1045[/TD]
[TD="class: xl734523"] 1.0[/TD]
[TD="class: xl734523"] COLLECT[/TD]
[TD="class: xl744523, align: right"]12/13/2016[/TD]
[TD="align: right"]1234578[/TD]
[/TR]
</tbody>[/TABLE]

Our interface will only allow a maximum of 999 units. Therefore, I need to create multiple lines of the same data that divide the units in each line as to not exceed 999.

Output Example:
[TABLE="width: 740"]
<tbody>[TR]
[/TR]
[TR="class: xl69"]
[TD="class: xl67, width: 51"]AcctNo[/TD]
[TD="class: xl67, width: 128"] Name[/TD]
[TD="class: xl67, width: 75"]ReferDate[/TD]
[TD="class: xl67, width: 48"]DocNo[/TD]
[TD="class: xl67, width: 65"]PatientID[/TD]
[TD="class: xl68, width: 56, align: right"]units[/TD]
[TD="class: xl68, width: 61, align: right"]num[/TD]
[TD="class: xl67, width: 61"]Code[/TD]
[TD="class: xl72, width: 73"]Service[/TD]
[TD="class: xl72, width: 61"]Claim ID[/TD]
[TD="width: 61"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361004[/TD]
[TD="class: xl65"]TEST1[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66, align: right"]699.67[/TD]
[TD="class: xl73"] 0.7[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234568[/TD]
[TD="class: xl75"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361004[/TD]
[TD="class: xl65"]TEST1[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66, align: right"]699.67[/TD]
[TD="class: xl73"] 0.7[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234568[/TD]
[TD="class: xl75"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361004[/TD]
[TD="class: xl65"]TEST1[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66, align: right"]699.67[/TD]
[TD="class: xl73"] 0.7[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234568[/TD]
[TD="class: xl75"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl75"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361005[/TD]
[TD="class: xl65"]TEST2[/TD]
[TD="class: xl70"]10/31/2014[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl66, align: right"]818[/TD]
[TD="class: xl73"] 0.8[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234569[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361005[/TD]
[TD="class: xl65"]TEST2[/TD]
[TD="class: xl70"]10/31/2014[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl66, align: right"]818[/TD]
[TD="class: xl73"] 0.8[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234569[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361006[/TD]
[TD="class: xl65"]TEST3[/TD]
[TD="class: xl70"]10/11/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl66, align: right"]657.5[/TD]
[TD="class: xl73"] 0.7[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234570[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361006[/TD]
[TD="class: xl65"]TEST3[/TD]
[TD="class: xl70"]10/11/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl66, align: right"]657.5[/TD]
[TD="class: xl73"] 0.7[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234570[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361007[/TD]
[TD="class: xl65"]TEST4[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]826[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl66, align: right"]849.33[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234571[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361007[/TD]
[TD="class: xl65"]TEST4[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]826[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl66, align: right"]849.33[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234571[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361007[/TD]
[TD="class: xl65"]TEST4[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]826[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl66, align: right"]849.33[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234571[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361008[/TD]
[TD="class: xl65"]TEST5[/TD]
[TD="class: xl70"]3/12/2015[/TD]
[TD="class: xl65"]817[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl66, align: right"]739[/TD]
[TD="class: xl73"] 0.7[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234572[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361008[/TD]
[TD="class: xl65"]TEST5[/TD]
[TD="class: xl70"]3/12/2015[/TD]
[TD="class: xl65"]817[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl66, align: right"]739[/TD]
[TD="class: xl73"] 0.7[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234572[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361009[/TD]
[TD="class: xl65"]TEST6[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]865[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl66, align: right"]973.8[/TD]
[TD="class: xl73"] 1.0[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234573[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361009[/TD]
[TD="class: xl65"]TEST6[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]865[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl66, align: right"]973.8[/TD]
[TD="class: xl73"] 1.0[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234573[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361009[/TD]
[TD="class: xl65"]TEST6[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]865[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl66, align: right"]973.8[/TD]
[TD="class: xl73"] 1.0[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234573[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361009[/TD]
[TD="class: xl65"]TEST6[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]865[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl66, align: right"]973.8[/TD]
[TD="class: xl73"] 1.0[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234573[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361009[/TD]
[TD="class: xl65"]TEST6[/TD]
[TD="class: xl70"]4/30/2013[/TD]
[TD="class: xl65"]865[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl66, align: right"]973.8[/TD]
[TD="class: xl73"] 1.0[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234573[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361010[/TD]
[TD="class: xl65"]TEST7[/TD]
[TD="class: xl70"]9/20/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl66, align: right"]529[/TD]
[TD="class: xl73"] 0.5[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234574[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361011[/TD]
[TD="class: xl65"]TEST8[/TD]
[TD="class: xl70"]9/21/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl66, align: right"]529[/TD]
[TD="class: xl73"] 0.5[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/14/2016[/TD]
[TD="class: xl71, align: right"]1234575[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361011[/TD]
[TD="class: xl65"]TEST8[/TD]
[TD="class: xl70"]12/23/2016[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl66, align: right"]632.5[/TD]
[TD="class: xl73"] 0.6[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234575[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361011[/TD]
[TD="class: xl65"]TEST8[/TD]
[TD="class: xl70"]12/23/2016[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl66, align: right"]632.5[/TD]
[TD="class: xl73"] 0.6[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234575[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361012[/TD]
[TD="class: xl65"]TEST9[/TD]
[TD="class: xl70"]2/8/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl66, align: right"]917.2[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234576[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361012[/TD]
[TD="class: xl65"]TEST9[/TD]
[TD="class: xl70"]2/8/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl66, align: right"]917.2[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234576[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361012[/TD]
[TD="class: xl65"]TEST9[/TD]
[TD="class: xl70"]2/8/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl66, align: right"]917.2[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234576[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361012[/TD]
[TD="class: xl65"]TEST9[/TD]
[TD="class: xl70"]2/8/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl66, align: right"]917.2[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234576[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361012[/TD]
[TD="class: xl65"]TEST9[/TD]
[TD="class: xl70"]2/8/2013[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl66, align: right"]917.2[/TD]
[TD="class: xl73"] 0.9[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234576[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361013[/TD]
[TD="class: xl65"]TEST10[/TD]
[TD="class: xl70"]11/22/2013[/TD]
[TD="class: xl65"]664[/TD]
[TD="class: xl65"]10[/TD]
[TD="class: xl66, align: right"]829[/TD]
[TD="class: xl73"] 0.8[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234577[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361013[/TD]
[TD="class: xl65"]TEST10[/TD]
[TD="class: xl70"]11/22/2013[/TD]
[TD="class: xl65"]664[/TD]
[TD="class: xl65"]10[/TD]
[TD="class: xl66, align: right"]829[/TD]
[TD="class: xl73"] 0.8[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234577[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361014[/TD]
[TD="class: xl65"]TEST11[/TD]
[TD="class: xl70"]3/12/2015[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]11[/TD]
[TD="class: xl66, align: right"]522.5[/TD]
[TD="class: xl73"] 0.5[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234578[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"]361014[/TD]
[TD="class: xl65"]TEST11[/TD]
[TD="class: xl70"]3/12/2015[/TD]
[TD="class: xl65"]99[/TD]
[TD="class: xl65"]11[/TD]
[TD="class: xl66, align: right"]522.5[/TD]
[TD="class: xl73"] 0.5[/TD]
[TD="class: xl73"] COLLECT[/TD]
[TD="class: xl74, align: right"]12/13/2016[/TD]
[TD="class: xl71, align: right"]1234578[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance for any help!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You must log in or register to reply here.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top