Hi again saziz,

Just to be clear, if you copy the formula below straight down all cells in
column B (in my example) you will have the effect I think you are after of
showing the average of each block of six values interpersed with cells that
appear blank. I presume the problem you are having is that it is
inconvenient to have to copy then paste every 6 cells down a column of 2,500
rows :-(

Regards,

Peter Beach

"Peter Beach" wrote in message
...
Hi saziz,

If you wanted a pure formula solution, try something like:

=IF(MOD(ROW(B1),6)=0,AVERAGE(OFFSET(A1,0,0,6,1))," ")

That will average the values in column A every 6 rows.

Just an idea.

Regards,

Peter Beach

"saziz" wrote in
message ...

Hi Folks,
I have a sheet with data in col. B & C 2500 rows.
I do average on every 6th. row down until 2,500 rows.
I find myself doing this quite often. Wondering if someone can help
me write a VBA code.

first range value is (B2:C7) and then next would be further 6 rows down
starting from (B8:C13) until where the data ends (about 2500 rows)

Thank you for your help.
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread:
http://www.excelforum.com/showthread...hreadid=498143