Unique Value Counting

 

 

 

 

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

 

Read all about the Defense Logistic Agency Bidding System

 

 
 
 
 
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