I was being a bit simple-minded about the text matching and hadn't realised you wanted to count "text, text" as two occurences.

That solution is so awful it's brilliant. I wouldn't have even tried to do it in Excel - I'd have exported it all and used something else.