Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

PivotTable

Count Distinct Values in an Excel 2013 PivotTable

By Jeff Lenning | May 16, 2013 |

This post demonstrates how to count the number of distinct (unique) values in an Excel 2013 PivotTable.  Prior to Excel 2013, this capability was not built-in to the PivotTable feature.  For Excel versions earlier than 2013, there are a variety of different workarounds available, some use VBA code, some use helper formulas, and some of…

Read More