How to reference a active column in excel-tricky

[AlekM]

I know the basic paste in excel with active reference, however I ge
stuck when I want to paste columns that will reference every thir
cell.

A simple example:

---------ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF
Row1: 5-------------A--------30---------C---------60---------E


I want to put cell on another spreadsheet that will be right next t
each other that will calculate A5/6, C5/6, E5/6 etc

But these cells are next to each other so if I copy the first one i
gives me A5/6, B5/6, C5/6 etc.

Basicaly how to tell excel that these cells that will calculat
something should reference every second cell.

Thanks

 

[Frank Kabel]

Hi
try the following (if you start in column A on your other sheet)
=OFFSET('sheet1'!$A$5,0,(COLUMN()-1)*2)/6
copy to the right

 

[AlekM]

Frank

Thanks to your responce, but I am not sure how to incorporate it m
formula.

The actual formula I use is

=COVAR(PortfolioDeviation!$H$9:$H$15000,PortfolioDeviation!L9:L15000)

and I want the next cell over if I copy paste to read
=COVAR(PortfolioDeviation!$H$9:$H$15000,PortfolioDeviation!P915000)

and then

=COVAR(PortfolioDeviation!$H$9:$H$15000,PortfolioDeviation!T9:T15000)

and so on. I am not sure how the ofset formula can ce incorporated wit
the covarience formula

 

[Frank Kabel]

Hi
if your first COVAR function is in column A use
=COVAR(PortfolioDeviation!$H$9:$H$15000,OFFSET(PortfolioDeviation!$L$9:
$L$15000,0,(COLUMN()-1)*4))
copy this to the right

If your formula start in a different column you have to change the
part: COLUMN()-1 accordingly (change '-1' to '-column_start')