I have a worksheet with two columns: ColA with over 320,000 rows of data of file sizes in bytes, and ColB which contains the equivelant value of ColA in megabytes.
I am in need to divide ColA data into segements separated with one empty row. Dividing should occure when the total value of ColB reaches around 900 megabyte more or less.
In addition, each segment's total of megabytes besides the total number of rows for that segment should be placed in the last row of that segment in ColC and ColD.
I am attaching part of my real data in both columns A & B in Sheet1. I have also manually caculated and segmented the first two groups of ColA in Sheet2 as an example of the final product.
Can I get some expert assistance with this request please?
Many thanks in advance.
T.
Bookmarks