• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

distinct count in pivot table excel 2010

Formula's
=IF(SUMPRODUCT(($A$2:A2=A2)*($B$2:B2=B2))>1,0,1) or
=IF(COUNTIF($B$2:B2,B2)=1,1,0)
not working as work distinct count in excel 2013.

And
I can't use PowerPivot because receiver does not have PowerPivot.
 
Hi ,

Upload a workbook with data in it , specify the cells which need the formula , and you will get an answer faster.

Narayan
 
Hi MohitMathur1234,

There is no distinct count in Pivot Table in Excel 2010.
The ugly workaround, if some-one is not willing to use formula's, is to re-invoke a pivot on the pivot range with ALT + D + P.

Example attached.

cheers
Guido
 

Attachments

  • count distinct.xlsx
    14.7 KB · Views: 2
Best bet, is to just add helper column to source data range. Or use intermediate calculated table as source for PivotTable.

As was previously indicated, there's no direct way to calculate distinct count with standard PivotTable.
 
You must log in or register to reply here.
Back
Top