Improve the accuracy of your date by learning how to calculate the average of distinct counts in Excel using PivotTables.