You're welcome, and appreciate the feed-back.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"excel0003" wrote
in message ...
RD,
it works
thank you very much.
pk
RagDyer Wrote:
Enter this anywhere, and copy down as needed:
=AVERAGE(INDEX(A:A,5*ROWS($1:1)-4):INDEX(A:A,5*ROWS($1:1)))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------
"excel0003"
wrote
in message
...
davesexcel Wrote:
is this in one cell??
=AVERAGE(A1:A5)&" "&AVERAGE(A6:A10)&" "&AVERAGE(A11:A15)
I have 1 column but 1000 rows.
i want to get,
1st cell =average a1 to a5
2nd cell=average of a6 to a10
continue to
last cell= average A(1000-5) to a1000.
will appreciate
--
excel0003
------------------------------------------------------------------------
excel0003's Profile:
http://www.excelforum.com/member.php...o&userid=37914
View this thread:
http://www.excelforum.com/showthread...hreadid=574434
--
excel0003
------------------------------------------------------------------------
excel0003's Profile:
http://www.excelforum.com/member.php...o&userid=37914
View this thread: http://www.excelforum.com/showthread...hreadid=574434