How Do I Count Distinct Records in an Excel Pivot Table?

1. Add a column to the database with which you are working; give it a text heading of your choice and add this field to your pivot table.
2. Enter the following formula in the first cell of the column you created:=IF($A$2:$A2=A2)>1,0,1)where A is the column which you are searching and 2 is the first row of data in your pivot table.
3. Copy the formula down the entire column you created and the cells in that column will display the number of distinct records in that row.