COLLECT formula year criteria confusion

Arush Godha

Hi, I am trying to find the maximum value of values in Column A based on the year it is occurring as per dates listed in Column B. For e.g., finding the minimum value for all 2015 values in Column A.

This is the formula I came up with but it is not working:

=MAX(COLLECT([Column A]:[Column A], [Column B]:[Column ], YEAR(@cell) = 2015))

Please help!

Paul Newcome

Can you be more specific in regards to "it is not working"? Are you getting an unexpected number, or are you getting an error message?