1. Open the datasheet, select the data to be counted, click Insert, and then click PivotTable.
2. In the new table, check the employer's field name on the right, and there will be non-duplicate names on the left.
3. Drag the employer into the value box to count, so as to count the number of times each name appears in the original table.