+ Reply to Thread
Results 1 to 5 of 5

Queation about monthly and weekly averages

  1. #1
    Omkar
    Guest

    Queation about monthly and weekly averages

    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


  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    can you post a sample of your data

  3. #3
    Max
    Guest

    Re: Queation about monthly and weekly averages

    Omkar,

    FWIW, I've since responded to your follow on queries in your earlier post,
    re: 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
    >
    >


  4. #4
    Omkar
    Guest

    Re: Queation about monthly and weekly averages

    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,
    > re: 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
    > >
    > >



  5. #5
    Max
    Guest

    Re: Queation about monthly and weekly averages

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1