lets say I have have two ranges a1:a300 and b1:b300 which have data in eg. a number from 1 to 100. Now lets say I want to do a calculation with a subset of the range eg. 100
lets take an example. find max correlation/sum between consecutive 100 numbers in each range
eg a1:a100 and b1:b100 and then a2:a101 and b2:b101 etc until a200:a300 and b200:b300
you would have 200 results of the loops and so would need to state for example the maximum correlation of the 200 loops.

Also the same could apply by fixing one range eg a1:a100 but changing the other eg b2:b101, b3:b102 etc then finding the max. How can you find a maximum value of the loop without outputing in specific cells and then finding max of that range?

cheers all