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 / Extract Unique Values from Selected Range

Excel has a formula called Count and CountIf. But Excel does not have a function for the Count of Unique values. DigDB can quickly extract or count the unique values in one or multiple selected range.

    Count / Extract Unique Values
    Practice file - unique-in-range-demo.xls (16k)

  1. Select the range(s) first, (use Ctrl+select for multiple selections), then invoke 'DigDB->Selected Area->Uniques->...'

    Count / Extract Unique Values

    If you choose to 'Extract' uniques, a new sheet will be created where unique values will be extracted, and there will be a column 'Count', that's how many times each unique values has appeared in the selected range.

    Count / Extract Unique Values

    If you choose to 'Count' uniques, then you get a quick count of how many unique values are there.

    Count / Extract Unique Values

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact

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.