I have a simple spreadsheet with years in column one, and values in the second one. I want to cluster the years in groups that add up to less than 1000 (and there is no year that has more than 1000). The first bunch of years have very small numbers, so there we'd have to find the exact amount of years that yield a number that is just under 1000 - i.e. whereby the next year would get us over that limit. And then the second group of 1000 would start with the first next year and again continue until the year that once again tips us over the limit. And so on until the last year. What is the best way to do this? Thanks!
-Stephan
-Stephan
