pivot table count unique values mac excel 2013

Pivot Table Count Unique Values on Mac Excel 2013

When working with data in Mac Excel 2013, you may need to count unique values in a pivot table. This can be a crucial step in analyzing and summarizing your data. In this article, we will explore how to count unique values using a pivot table in Mac Excel 2013.

To start, open your Mac Excel 2013 file and select the data range you want to analyze. Then, go to the 'Insert' tab and click on 'PivotTable' to create a new pivot table.

Next, drag the field that contains the values you want to count into the 'Values' area of the pivot table. Right-click on the field and select 'Summarize' > 'Count Unique'.

Alternatively, you can use VBA code to count unique values in Mac Excel 2013. The code is easy to learn, and I highly recommend using the macro recorder if you are new to VBA.

Here's an example of how you can use VBA code to count unique values:

```

Sub CountUniqueValues()

Dim rng As Range

Set rng = Range('A1:A10')

Dim cell As Range

For Each cell In rng.Cells

If cell.Value Like ''ABC'' Then

CountC rng, cell

End If

Next cell

End Sub

Function CountC(rng As Range, Cell As Range)

Dim i As Integer

For i = 1 To rng.Count

If rng(i).Value = Cell.Value Then

CountC = CountC + 1

End If

Next i

End Function

```

In this example, the VBA code loops through each cell in the range and checks if the value matches a specific condition (in this case, values that start with 'A', 'B', or 'C'). The `CountC` function counts the number of cells that match the condition.

If you are new to VBA, I recommend using the macro recorder to record your actions and then modify the code to fit your needs. You can also use online resources such as Excel-Easy.com to learn more about VBA programming.

In conclusion, counting unique values in a pivot table is an important step in analyzing and summarizing data in Mac Excel 2013. By using either the built-in 'Count Unique' feature or VBA code, you can easily count unique values in your data.

Pivot table count unique values mac excel 2013