Results 1 to 1 of 1

Querying for a cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2007
    Posts
    11

    Querying for a cell

    I was wondering how to write a function to search a column for one time, a second time and average everything in the next cell in between. Here would be an example

    A B C
    Time Number Average
    0:00.00 3 =timeAvg(A, 0:00.00, 1:00.00, B) [this would output 3.33]
    0:01.15 3 =timeAvg(A, 1:00.00, 2:00.00, B) [this would output 2.5]
    0:10.2 4 =tiimeAvg(A, 2:00.00, 3:00.00, B) [this would output 2]
    1:00.00 2
    1:15.0 3
    2:05.00 2
    2:13.3 1
    2:30.5 3
    3:00.00 35

    OK I know this probably looks crappy but if you can try to decipher it A2 says 0:00.00, B2 says 3, and B3 says =timeAvg(A, 0:00.00, 1:00.00, B) [this would output 3.33]. Everything column is separated by a space. If there is a better way to post this let me know.

    I don't know if this can even be done, but what as you can see it takes all
    times that include the first time (if it is in the column) but are less than (not including) the second time that are in the first column in and averages the numbers from the second column.

    Is this possible???

    Thanks
    Chris
    Last edited by solidsnake5698; 07-08-2007 at 01:04 AM. Reason: Make it a little eaiser to read

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