E
Eve
Hello,
Thank you for helping, as I am not too familiar with the advanced funtions
of Excel.
I am working with a very large worksheet and would like to add cells
together. I would like to add two cells (on two adjacent rows but same
column) every 7 columns apart.
eg.
A B C D E
F G
1 Days Date Value XAO Return XAO
Return AR
2 -2 02/12/2008 0.042 3437 0.1333 -0.023
-0.454
3 -1 03/12/2008 0.043 3427 0.083 -0.987
-0.587
4 0 04/12/2008 0.477 3553 -0.546 0.456
0.623
5 +1 05/12/2008 0.567 3438 0.9865 0.387
0.218
I would like to add cells G3:G4 for every one of my stocks as I want to
calculate the AR for each. Each of the stocks has the same format, and
therefore, in-between the AR column for each of the stocks is exactly 7
columns.
Hopefully, I would like to put the new values into a new column, so I can
just auto-fill down.
Thank you again. This is my first time posting here, I hope I have made my
question clear enough.
Thank you for helping, as I am not too familiar with the advanced funtions
of Excel.
I am working with a very large worksheet and would like to add cells
together. I would like to add two cells (on two adjacent rows but same
column) every 7 columns apart.
eg.
A B C D E
F G
1 Days Date Value XAO Return XAO
Return AR
2 -2 02/12/2008 0.042 3437 0.1333 -0.023
-0.454
3 -1 03/12/2008 0.043 3427 0.083 -0.987
-0.587
4 0 04/12/2008 0.477 3553 -0.546 0.456
0.623
5 +1 05/12/2008 0.567 3438 0.9865 0.387
0.218
I would like to add cells G3:G4 for every one of my stocks as I want to
calculate the AR for each. Each of the stocks has the same format, and
therefore, in-between the AR column for each of the stocks is exactly 7
columns.
Hopefully, I would like to put the new values into a new column, so I can
just auto-fill down.
Thank you again. This is my first time posting here, I hope I have made my
question clear enough.