Column C: Name
Column D: Date
Column H: Points
I want to see the highest point for the name in P3 for dates in this
year (2013).
I can do highest score for the name that's stored in P3, regardless of the year:
{=MAX(IF(C2:C10000=P3; H2:H10000; 0))}
Result: 612.
Expected result: 612.
And the highest score for the this year, regardless of name:
{=MAX(IF(YEAR(D2:D10000)=YEAR(TODAY()); H2:H10000; 0))}
Result: 596.
Expected result: 596.
I tried the following:
{=MAX(IF(AND(YEAR(D2:D10000)=YEAR(TODAY());C2:C10000=P3); H2:H10000; 0))}
Result: 0.
Expected result: 588.
I obviously misunderstood the whole concept, so how is it supposed to be done?
Johnny Rosenberg
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
