Overview

A user platform is trying to count the number of unique institutions listed under the 'Company' field, without counting duplicates. The current system does not support a direct way to count unique entries in the 'Company' field. 

Solution

Unfortunately, there is no report to find count of unique companies other than exporting data and sorting in Excel or Google Sheets.
However, you can speed it up by creating a personal reports with only Companies list.

1. Go to Reports > Personal
2. Create new report
3. Select Contacts > From Scratch
4. Select Company field only and save the report and add it to your dashboard
   
   
5. Save it to your dashboard.
6. Download the list of companies from your dashboard.
7. Open it in Excel or Google Sheets
8. Use the =UNIQUE(A;A) formula (as the list of companies is in the first column) to get only unique companies with no duplicates.
   
   Note: Also, please make sure that all of the users from the same company have exactly the same name of the company, as even a difference in a single letter will present it as a unique value.