I have been using a CSE Formula to find the max value of rows where another column has a specific Value:
I needed to add a second criteria, and after much searching, experimenting, this seems to work:{=MAX(IF(B:B=B11,I:I,D11))}
But it's so slow, it's driving me nuts. Is there a faster way?{=MAX(IF((I:I<A11)*(B:B=B11),I:I,D11))}
Bookmarks