Welcome Guest [Log In] [Register]
Assalamoalaikum, We hope you will enjoy your visit here.

Join our community!

If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Counting number of unique entries in a specified r
Topic Started: Mar 8 2007, 06:55 PM (135 Views)
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins


By using SUMPRODUCT along with COUNT to count only the number of unique entries in a specified range.

The range can be all in one column or row, or may span multiple (adjoining) columns/rows.

The formula would be written as: =SUMPRODUCT((1/COUNTIF(A1:C5,A1:C5&""))) where A1:C5 is replaced with the range you want to apply the count to.
Offline Profile Quote Post Goto Top
 
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Posted Image
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Roshnee · Next Topic »
Add Reply