May 09, 2014

How to count unique values in pivot table

More often than not if you are using any version prior to Microsoft Office Excel 2013, you would have faced the problem of counting uniques in a pivot table.

I found this solution sometime back which in-corporates the countif function so beautifully that you would think "that was so simple"

Check out: Download the example excel file here.

No comments: