+ Reply to Thread
Results 1 to 2 of 2

Constrain data for calulation in one column based upon date in another column

  1. #1
    Registered User
    Join Date
    10-28-2009
    Location
    Wilmington,DE
    MS-Off Ver
    Excel 2007
    Posts
    39

    Constrain data for calulation in one column based upon date in another column

    Dear Forum Members,

    I have tried to work this out on my own with no success - I don't really know how to begin the logic!

    Please Login or Register  to view this content.
    In the code above, YearStd is a Varient variable that calculates the standard deviation of the entire column. Instead, I need the calulation based upon the hour and the year. In column A I have time in the format 9/1/2011 1:00. (You can also see that I have struggled with the looping - right now, I have to know the last column and have commented out the "Do WHile" loop)

    I need to group the data by year then hour; e.g., all 2011 and 1:00 together, and then calculate standard deviation, among other things, for all values in year 2011 and hour 1:00 and possibly all values for all years in hour 1:00; etc.

    I have attached a sample spreadsheet to this post.

    Thank you for reading this request for help.

    Chris
    Last edited by ccolton; 12-08-2011 at 10:16 AM.

  2. #2
    Registered User
    Join Date
    10-28-2009
    Location
    Wilmington,DE
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Constrain data for calulation in one column based upon date in another column

    Sorry, I see now that the spreadsheet was not attached - here it is.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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