Discussion on:

2
Comments

Join the conversation!

Follow via:
RSS
Email Alert
0 Votes
+ -
=MAX(C2:C9*(A2:A9=MAX(A2:A9)))
will do a similar job when entered as an array function (ie with ctrl-sh-enter)
Has the advantage that it will find the larger of two values against the same date, can be adapted to use more criteria (eg a particular person) and it can be used to look to the left instead (though this could also be achieved using an INDEX and MATCH combination and I can't think I'd really use it unless I were trying to be deliberately obscure!)
0 Votes
+ -
Another way
DBlayney 2nd May 2012
Personally, I would use =SUMIF(A2:A9,MAX(A2:A9),C2:C9). This has the advantage that if the maximum date occurs twice in the date column, the total is deleivered rather than just the value for the first occurrence
Keyboard Shortcuts:
Prev
Next
Toggle
Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.