Pivot table count unique values

In order to count unique values in the Pivot Table, you have to do the following steps.

  1. Copy the following table into Excel (get the file). In the cellĀ C2 enter the following formula.

  1. Autofill for the rest of the cell in column C.

  1. Click inside the table and go to Insert -> Tables -> Pivot Table.
  2. In the Create PivotTable window use the following settings and click OK.

  1. In PivotTable Fields on the right side check both positions (Group and Name).

  1. Drag fields between areas, as shown on the image below.

  1. Now, you should see the following result.