Formula Causes Slow Updates

**jnnewton** · 11-20-2011, 02:06 PM

I have been using a CSE Formula to find the max value of rows where another column has a specific Value:

Please Login or Register  to view this content.

I needed to add a second criteria, and after much searching, experimenting, this seems to work:

Please Login or Register  to view this content.

But it's so slow, it's driving me nuts. Is there a faster way?

**Armando Montes** · 11-20-2011, 02:12 PM

Try a limited range:
{=MAX(IF(B1:B100=B11,I1:I100,D11))}

**shg** · 11-20-2011, 02:36 PM

jnnewton, please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**jnnewton** · 11-20-2011, 03:39 PM

I have done so.

Re: Looking For A Faster Way