Copying select cells
Posted by riha on June 25, 2001 2:45 AM
My column A has closing prices on 1200 days of a particular stock.
Column B has average closing price for every 5 days on Col.A (B5 has average of A1 to A5, B10 has avg of A6 to A10...)
I need the contents of A5,A10,A15... (every 5th row on column B), in a separate column (say E). I do not want the values (zero / blank) in cells A2,A3,A4,A6,A7....
In short I need only the averages on col.E without the blank cells inbetween.
I tried copying the contents and setting autofilter on. But it copies only the absolute values that do not change when I change the values in column A.
Can someone help?