Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Wisconsin
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date counting/averaging (97)

    I have a table where each row represents an occurence ex. a dose of a medication given. One of the rows represents the date for which it took place.
    I have multiple occurences of the same date. I've sorted the data by date, but now want to get a handle on how frequently something occured on any given date. Or better yet what is the max and min for the listed dates and the average number of occurences for the whole thing (e.g. min 1, max 12, average is 4 for the whole range)
    Any one have any ideas? Or is my question clear as mud?
    Thanks,
    Mike

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date counting/averaging (97)

    Have you considered using a Pivot Table? It would allow you to view mins, maxes, counts and averages - among other things.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date counting/averaging (97)

    You might find the Database [eg Daverage(), Dmin() etc] functions useful.
    RuthC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •