COLLECT formula year criteria confusion
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))
Help Article Resources
Check out the Formula Handbook template!