Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Index/Match/Max error (2003)

    It appears that my formula is missing something because the return data is incorrect.
    =MAX(Download!$H$1:$H$1000,$A4,INDEX(Download!$A$1 :$P$10,0,MATCH(B$3,Download!$A$1:$P$1,0)))
    I was hoping that my formula would give me the count based on the Maximum time (latest time) and the Name...My result is a 747 instead of 697 (the correct answer).
    TIA for for your time and effort.
    Attached Files Attached Files

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

    Re: Index/Match/Max error (2003)

    Both rows for Wake Forrest have the same time. Do you want to sum the counts? If so, you can use this array formula in B4 (confirm with Ctrl+Shift+Enter):

    =SUM((Download!$H$2:$H$10=A4)*(Download!$D$2:$D$10 =MAX(IF(Download!$H$2:$H$10=$A4,Download!$D$2:$D$1 0)))*Download!$I$2:$I$10)

    If you want the highest of the counts for the most recent time, replace SUM with MAX at the beginning of the formula.

  3. #3
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Index/Match/Max error (2003)

    You got all the right answers. Thank you Hans for coming to the rescue...

Posting Permissions

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