Where Range A1:B10 contains the data
| Sun | April |
| Mon | Mon |
| Tue | Tue |
| Wed | Wed |
| Thu | May |
| Fri | Fri |
| Sat | Sat |
| Sun | Sun |
| Mon | Mon |
| Jun | Tue |
=SUMPRODUCT(($A$1:$B$11<>"")/COUNTIF($A$1:$B$11,$A$1:$B$11&"")) = 10
Monday, August 27, 2012
Counting Unique Values in a Range
Nice and simple but effective, this formula counts how many unique items there are in a range.
Where Range A1:B10 contains the data
=SUMPRODUCT(($A$1:$B$11<>"")/COUNTIF($A$1:$B$11,$A$1:$B$11&"")) = 10
Where Range A1:B10 contains the data
=SUMPRODUCT(($A$1:$B$11<>"")/COUNTIF($A$1:$B$11,$A$1:$B$11&"")) = 10
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment