Every Other Row

[Docdigit]

Is there a way to get Excel to calculate Standard Deviation on every
other row (there are 2400 rows, so manually putting them in isn't really
an option.)

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[Max]

One way to try ..

Assume the source data is in A1:A2400 in Sheet1

In a new Sheet2
-----------------------
Put in A1: =OFFSET(Sheet1!$A$1,ROW(A1)*2-2,)
Copy A1 down to A1200

This'll extract every other row from Sheet1's A1:A2400
(i.e. from Sheet1's A1, A3, A7, A9, ... A2399)

Then just put in say, B1: =STDEV(A1:A1200)

 

[Alan Beban]

Is there a way to get Excel to calculate Standard Deviation on every
other row (there are 2400 rows, so manually putting them in isn't really
an option.)

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, then if
you mean every odd-numbered row

=STDEV(ArrayAlternates(A1:A2400))

If you mean every even-numbered row

=STDEV(ArrayAlternates(A1:A2400,FALSE))

Alan Beban