Learn Excel Episode 758: Pivot Unique

Posted in Companies, Podcasts on July 15, 2008

Can you use a pivot table to measure how many unique combinations of customer and product appear in a data set? Well, you can't do it natively, but in Episode 758, we take a look at a formula such as =IF(SUMPRODUCT(($B$2:$B2=B2)*($D$2:$D2=D2))>1,0,1) which will allow the calculation to work. Also - a look at the Amazon Kindle.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Pivot Table, unique