Suppose I have a list of values like so:
1
2
3
4
5
6
I want to find every combination that involves consecutive members of this list, for e.g.:
(
// every combination of one element
1, 2, 3, 4, 5, 6,
// every combination of two con. elements
1+2, 2+3, 3+4, 4+5, 5+6,
// every combination of three con. elements
1+2+3, 2+3+4, 3+4+5, 4+5+6,
// every combination of four con. elements
1+2+3+4, 2+3+4+5, 3+4+5+6,
// every combination of five con.elements
1+2+3+4+5, 2+3+4+5+6,
// every combination of six con. elements
1+2+3+4+5+6,
)
As you can see there are n(n+1)/2 of such combinations. Any excel formula I can use to find this and ideally show it as a column using tocol?
