Angular Repeating sequence

[TOKYOJ1]

Hello,

I have a long repeating angle/circular sequence as example below which repeats at every 360 degrees. I wish to add 360, 720, 1080, 1440 (circles) at every turning points so I get an ascending sequence.

Original sequence	Desired result	Note
12	12
29	29
120	120
240	240
359	359
2	362
15	375
40	400
120	480
270	630
325	685
359	719
3	723	add 360
9	729
20	740
111	831
233	953
345	1065
5	1085	add 720

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Can anyone assist in this?

Thanks in advance

 

[TOKYOJ1]

Sorry the correct sequence:

Original sequence	Desired result	Note
12	12
29	29
120	120
240	240
359	359
2	362	add 360
15	375
40	400
120	480
270	630
325	685
359	719
3	723	add 720
9	729
20	740
111	831
233	953
345	1065
5	1085	add 1080

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Tetra201]

Assuming your Original Sequence has a non-empty header with at least one letter in cell A1, try placing the following formula in cell B2 and drag-copying it down as needed:

=A2+360*(SUMPRODUCT(--($A$1:A1>$A$2:A2))-1)