DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Count of Unique Values in Roll-up (pivot table)

Excel has a Count formula, and it also has a Count function in Pivot Table and Subtotal. But Pivot Table and Subtotal do NOT support the Count of Unique Values.

Below is an Sales transaction list table. Using Pivot Table or Subtotal, you can find out for example, the number (Count) of transactions in each Store. But you cannot see, for example, the Variety of Product (Count of Unique Values in 'Product') sold by each store. DigDB's Roll-up allows you to calculate this:

    Count of Unique Values - Roll-up / pivot table
    Practice file - count-unique-values-demo.xls (16k)

  1. Click any cell within your list area, Invoke 'DigDB->Roll up...'

    Count of Unique Values - Roll-up / pivot table

  2. Set summary criteria: Count of Unique Values in Product by Store

    Count of Unique Values - Roll-up / pivot table

    Count of Unique Values - Roll-up / pivot table

    Count of Unique Values - Roll-up / pivot table

  3. Click 'OK' to get the roll up. Result is shown in a new list on a new sheet

    Count of Unique Values - Roll-up / pivot table

    Besides Count of Unique Values, DigDB's roll up also supports Median, MODE, Standard Deviation and a total of 21 statistical functions. This give users far more aggregate power than Pivot table and Subtotal.

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (free forum)

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.