CODEWITHSUNDEEP
excelexcel-formula
Paul Ryan
Paul Ryan

Reputation: 13

Excel, magnitude of every three rows

I have data with about 6000 rows. It is split as such:

0   | 0.01846

1   |-0.04517

2   |1.01471

0   |0.01846

1   |-0.04745

2   |1.00769

0   |0.03006

1   |-0.04745

2   |1.00922

0   |0.03326
.
.
.

Basically the 0,1,2 pattern repeats till the end. Lets call the right side values axis0, axis1, axis2..... Is it possible to plug in the values of axis0,axis1,axis2 into a repeating equation of sqrt(axis0^2+axis1^2+axis2^2) all the way down?

Upvotes: 1

Views: 46

Answers (1)

A.S.H
A.S.H

Reputation: 29352

C1: =IF(A1=0,SQRT(SUMSQ(B1:B3)),"")

Copy/Paste along column C will make the result appear on the beginning of each triplet.

Upvotes: 1

Related Questions