So if every 100'th row had that happen, then you would want rows 1 to 99 saved in B at the time row 100 was looked at, and store that in a file, and then when row 200 was encounted, you would want rows 1 to 199 saved in B including the row at 100 that triggered the previous save... and so on, with each time it storing a larger and larger extract, because you said all rows before that row?
Or do you only want to store in the sections, saving each block of increases-only ?
What do you want to have happen if two rows beside each other decrease? like 1, 3, 5, 4 (decrease relative to 5), 2 (decrease relative to 4) ?
