Quote:
Originally Posted by Pecoflyer
Did you use large ranges hat time ? Like A1:A65535 ? That would slow thing down
If necessary Dynamic ranges are best
|
You know I think I did. It was shortly after I discovered the sum if formula which was much more effective for the application I was doing. But it is evident now that the sumproduct formula is exactly what I needed. Thanks again I will mark as solved.