| 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: |
| Counting number of unique entries in a specified r | |
|---|---|
| Tweet Topic Started: Mar 8 2007, 06:55 PM (135 Views) | |
| Ahmaq | Mar 8 2007, 06:55 PM Post #1 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
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. |
![]() |
|
| Ahmaq | Mar 8 2007, 06:55 PM Post #2 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
Posted Image |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Roshnee · Next Topic » |








5:33 AM Jul 11