Unique Value Counting

 

 

 

 

HomeOur CompanyContact Us
Business Solutions                                                      Business Intelligence                                                      Business Success
Custom software solutions to fit your business needs.
586-899-5599

 

Browse Services
Database
Web
Server
ERP
eCommerce
Custom Software
Consulting

 

Excel Links
Microsoft Solutions
Resources
Tips
Fun Stuff

Back to Excel Tips Index

Synt. =SUMPRODUCT((Rng_1<>"")/COUNTIF(Rng_1, Rng_1&""))

ex. =SUMPRODUCT((A2:A100<>"")/COUNTIF(A2:A100,A2:A100&""))

Note: Use the smallest range possible due to slow calculation times. See Creating Dynamic Ranges.

Back to Excel Tips Index
 
Send mail to excelchampion@excelchampion.com with questions or comments about this web site.
Copyright © 2008 Excel Champion Consulting