Hi, I am trying to find a way to cluster cells together if their sum from left to right is over a certain threshold.
But the ttl row of cells must be equal to the original.
For instance,
assume threshold is greater than 600
the original dataset is (in a row):
500, 200, 1200, 300, 300, 200, 100, 100, 300, 60, 1200, 700
the outcome would be in row-format:
700, 0, 1200, 600, 0, 700, 0, 0, 0, 1260, 0, 700
anyone know how to build a formula to come up w the outcome row?
But the ttl row of cells must be equal to the original.
For instance,
assume threshold is greater than 600
the original dataset is (in a row):
500, 200, 1200, 300, 300, 200, 100, 100, 300, 60, 1200, 700
the outcome would be in row-format:
700, 0, 1200, 600, 0, 700, 0, 0, 0, 1260, 0, 700
anyone know how to build a formula to come up w the outcome row?
