I have annual data for concentrations of various species for last
couple of years. I want to find out monthly (12 values) as well as
weekly averages(52 values) for these years.
I did it manually for one year, but its taking lot of time.

Can it be done using single formula and then copying it down the column
to get these values?

Please help me.

Thanks,
Omkar

can you post a sample of your data


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552896

Omkar,

FWIW, I've since responded to your follow on queries in your earlier post,
http://tinyurl.com/qkm2r
(detail explanations and a link to a sample file as well <g)

You should be able to grasp the suggested formula's workings (a single
formula in a starting cell of your choice, then straight copy down), and
modify accordingly to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Omkar" wrote:
I have annual data for concentrations of various species for last
couple of years. I want to find out monthly (12 values) as well as
weekly averages(52 values) for these years.
I did it manually for one year, but its taking lot of time.

Can it be done using single formula and then copying it down the column
to get these values?

Please help me.

Thanks,
Omkar

Hi Max,

I got it. Since I wasn't clear about *7-6 I chose wrong cells and ended
up in circular references. So I could not get it. But finally I got it.

Thank you very much for help.

Bye.
Omkar
Max wrote:
Omkar,

FWIW, I've since responded to your follow on queries in your earlier post,
http://tinyurl.com/qkm2r
(detail explanations and a link to a sample file as well <g)

You should be able to grasp the suggested formula's workings (a single
formula in a starting cell of your choice, then straight copy down), and
modify accordingly to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Omkar" wrote:
I have annual data for concentrations of various species for last
couple of years. I want to find out monthly (12 values) as well as
weekly averages(52 values) for these years.
I did it manually for one year, but its taking lot of time.

Can it be done using single formula and then copying it down the column
to get these values?

Please help me.

Thanks,
Omkar

Glad to hear that, Omkar !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Omkar" wrote:
Hi Max,

I got it. Since I wasn't clear about *7-6 I chose wrong cells and ended
up in circular references. So I could not get it. But finally I got it.

Thank you very much for help.

Bye.
Omkar