Did you use large ranges hat time ? Like A1:A65535 ? That would slow thing down


If necessary Dynamic ranges are best

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.