+ Reply to Thread
Results 1 to 5 of 5

Display a weekly summary

  1. #1
    markag
    Guest

    Display a weekly summary

    Hi all,

    I have a full years worth of data, a value for every day of the year, and I
    need to have a worsheet that summarizes the previous weeks data. I would like
    to show the value for each day of the week, monday through sunday. I'm
    somewhat new at excel and I don't have a lot of experience with date & time
    functions. If someone could help me out I would really appreciate it.

    Thank you,

  2. #2
    shail
    Guest

    Re: Display a weekly summary

    Hi Markag,

    Send me an example over my email box, i guess i can do it.


    Thanks,

    Shail


    markag wrote:
    > Hi all,
    >
    > I have a full years worth of data, a value for every day of the year, and I
    > need to have a worsheet that summarizes the previous weeks data. I would like
    > to show the value for each day of the week, monday through sunday. I'm
    > somewhat new at excel and I don't have a lot of experience with date & time
    > functions. If someone could help me out I would really appreciate it.
    >
    > Thank you,



  3. #3
    markag
    Guest

    Re: Display a weekly summary

    My data is arranged like this

    Date Daily Values
    1/1/2006 75%
    1/2/2006 82%
    1/3/2006 57%
    . .
    . .
    . .
    12/31/2006 78%

    I just want to pull the data for the previous week into a separate worksheet
    in the same file. I don't need someone to do it for me; I would like to
    learn how so I can do it again later if needed. Would I have to use some
    sort of VLOOKUP and TODAY functions?

    "shail" wrote:

    > Hi Markag,
    >
    > Send me an example over my email box, i guess i can do it.
    >
    >
    > Thanks,
    >
    > Shail
    >
    >
    > markag wrote:
    > > Hi all,
    > >
    > > I have a full years worth of data, a value for every day of the year, and I
    > > need to have a worsheet that summarizes the previous weeks data. I would like
    > > to show the value for each day of the week, monday through sunday. I'm
    > > somewhat new at excel and I don't have a lot of experience with date & time
    > > functions. If someone could help me out I would really appreciate it.
    > >
    > > Thank you,

    >
    >


  4. #4
    markag
    Guest

    Re: Display a weekly summary

    My data is arranged like this

    Date Daily Values
    1/1/2006 75%
    1/2/2006 82%
    1/3/2006 57%
    . .
    . .
    . .
    12/31/2006 78%

    I just want to pull the data for the previous week into a separate worksheet
    in the same file. I don't need someone to do it for me; I would like to
    learn how so I can do it again later if needed. Would I have to use some
    sort of VLOOKUP and TODAY functions?

    "shail" wrote:

    > Hi Markag,
    >
    > Send me an example over my email box, i guess i can do it.
    >
    >
    > Thanks,
    >
    > Shail
    >
    >
    > markag wrote:
    > > Hi all,
    > >
    > > I have a full years worth of data, a value for every day of the year, and I
    > > need to have a worsheet that summarizes the previous weeks data. I would like
    > > to show the value for each day of the week, monday through sunday. I'm
    > > somewhat new at excel and I don't have a lot of experience with date & time
    > > functions. If someone could help me out I would really appreciate it.
    > >
    > > Thank you,

    >
    >


  5. #5
    Ron de Bruin
    Guest

    Re: Display a weekly summary

    Install EasyFilter

    You can filter and copy weeks to another sheet very easy
    http://www.rondebruin.nl/easyfilter.htm

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "markag" <markag@discussions.microsoft.com> wrote in message news:DAA8EE3F-12DD-4D19-B2E3-DC9B95A5FA1D@microsoft.com...
    > My data is arranged like this
    >
    > Date Daily Values
    > 1/1/2006 75%
    > 1/2/2006 82%
    > 1/3/2006 57%
    > . .
    > . .
    > . .
    > 12/31/2006 78%
    >
    > I just want to pull the data for the previous week into a separate worksheet
    > in the same file. I don't need someone to do it for me; I would like to
    > learn how so I can do it again later if needed. Would I have to use some
    > sort of VLOOKUP and TODAY functions?
    >
    > "shail" wrote:
    >
    >> Hi Markag,
    >>
    >> Send me an example over my email box, i guess i can do it.
    >>
    >>
    >> Thanks,
    >>
    >> Shail
    >>
    >>
    >> markag wrote:
    >> > Hi all,
    >> >
    >> > I have a full years worth of data, a value for every day of the year, and I
    >> > need to have a worsheet that summarizes the previous weeks data. I would like
    >> > to show the value for each day of the week, monday through sunday. I'm
    >> > somewhat new at excel and I don't have a lot of experience with date & time
    >> > functions. If someone could help me out I would really appreciate it.
    >> >
    >> > Thank you,

    >>
    >>




+ 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