Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    min/max reference (2003)

    Problem: column 1 contains dates (by day). Column 2 contains bits of data for each day (1 per day). I would like to run a min/max analysis on column 2, and have the result give me the respective date the min/max occurred. Any hwelp?
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: min/max reference (2003)

    What if the minimum or maximum occurs on more than one day? Is it sufficient to return the first day on which it occurs, or do you need to know all dates?

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: min/max reference (2003)

    Just the first would be ok.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: min/max reference (2003)

    See attached. It uses a combination of INDEX and MATCH.
    Attached Files Attached Files

Posting Permissions

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