+ Reply to Thread
Results 1 to 2 of 2

Creating an average from a set of data based on an initial start and end date and time

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Creating an average from a set of data based on an initial start and end date and time

    Hello Everyone,

    I have some basic excel formula skils but nothing too complex so i will try to explain my issue and hopefully you can provide help. I would very much appreciate any information you can give me.

    So i have a long list of data 'x' and each data point has date and time 'y' and i have another table which has the dates 'z-1' & 'z' and i would like to calculate an average value of 'x' from the range 'z-1 to z' from the list 'y' so this can be a continual table with varying averages


    'z-1' 3/8/12 8:00
    'z' 3/9/12 8:00 AVG 'x' 15.395 (this is the value i am looking for)
    'z+1' and so on... AVG 'x+1) and so on...

    long list of data....

    'y' 3/8/12 8:00 'x' 15.35
    'y' 3/8/12 9:00 'x' 15.40
    'y' 3/8/12 10:00 'x' 15.40
    'y' 3/8/12 11:00 'x' 15.43

    Any help would be great, thanks.

    Mike.

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Creating an average from a set of data based on an initial start and end date and time

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Monthly Average Based off a start and end date?
    By ImpetuousRacer in forum Excel General
    Replies: 9
    Last Post: 06-13-2012, 09:13 PM
  2. Replies: 4
    Last Post: 06-02-2012, 11:26 AM
  3. Import of data based on start and end time
    By oskars in forum Excel General
    Replies: 1
    Last Post: 05-14-2012, 05:11 AM
  4. Replies: 5
    Last Post: 03-21-2012, 08:07 AM
  5. Replies: 1
    Last Post: 03-31-2011, 05:03 PM

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