I have a large spreadsheet of customer data. I've set up a sample spreadsheet with some simple fake data. You can view the sample data (with edit privileges).
I need a formula to be able to count the number of companies that have been contacted. So it needs to count the non-blank cells in column E, but take into account if there are multiple contacts at the same company, evident by having the same value in column A.
In this sample data the formula would give a value of 4, as there are 6 non-blank cells in column E, but A6, A7 and A8 have the same value and should only count as 1.