+ Reply to Thread
Results 1 to 3 of 3

Daily Average grouped by Julian Week

  1. 06-06-2011, 04:44 PM #1
    XANADU79
    XANADU79 is offline
    Registered User
    Join Date
    06-06-2011
    Location
    Oregon, USA
    MS-Off Ver
    Excel 2003
    Posts
    14

    Daily Average grouped by Julian Week

    Needing a formula that groups the calculated daily average by Julian week and excludes values of "0".
    Reply With QuoteRegister To Reply
  2. 06-07-2011, 10:09 AM #2
    davegugg
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Daily Average grouped by Julian Week

    Is this an Excel question or an Access question?
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave
    Reply With QuoteRegister To Reply
  3. 06-07-2011, 10:28 PM #3
    XANADU79
    XANADU79 is offline
    Registered User
    Join Date
    06-06-2011
    Location
    Oregon, USA
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Daily Average grouped by Julian Week

    Excel.

    I have the data on one sheet, and have started a pivot table on another, however, I'm not sure of the formula to make this work on a rolling date basis.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1