Strange, I was certain I sent a reply.
It seems to give the right numbers with a PT (Thanks for suggesting!), but I'm interested to understand what went wrong with the Countif I performed... for my general knowledge and for some more data manipulation I'm going to do on a subset of the data set at the next stage.
Quote Originally Posted by Norie View Post
What happens if you create a pivot table from the original table with the company name as a row field and count of company name in the data section?