- Mar 25, 2008
Originally I only needed the latest date in a list - simple, Max(A2:A7). Now I need to only consider end dates where the Extended Total is >0. I understand the basics of how array formulas work and have written some simple ones, but I am struggling with an array formula that will give me the max of col A when Col B > 0. In the following example rows 3 and 5 would be excluded and the result would be 5/31/2016. Would really appreciate some help.
|1||Coverage Ends||Extended Total|