I'm wanting to perform an iterative sum over a set of 24 consecutive random values that are a part of a total 96 values. My goal is to see which sum of 24 consecutive numbers (1-24, 2-25, 3-26, ... , 73-96) has the greatest sum. I've thought about using a macro or some kind of loop to do this, but I'm unsure exactly where to start. Any ideas?
... View more