Haha true, and thanks for the reply. Unfortunately There's no way in a million years I'm getting a faster computer, and I made this myself to try and save myself some time at work.

I guess I was just wondering if there was a simpler way to do this? All I'm doing is counting the number of profiles, by risk, per person, from the roles sheet. I don't mind adding another column or two? Surely there must be an easier way? Those array formulas are SO slow!

Thanks
John