Counting unique rows in spreadsheets

Question

How do you run the COUNTUNIQUE function on several columns?

Running COUNTUNIQUE(A1:C3) gives me 8, because there are 8 unique values, I want it to return 3 because I have 3 unique rows.

| A  | B  |  c  |
-----------------
| a  | 1  |     |
| b  | 2  | foo |
| b  | 2  | foo |
| c  | 3  | bar |

P.S. I use Google spreadsheets, but I guess it's the same in Excel and LibreOffice Calc

Did you find the answer of @joseph4tw useful? I know I did. Perhaps you can flag it as such and let other people benefit from your Q&A!

joseph4tw · Accepted Answer · 2012-12-12 18:42:18Z

up vote 4 down vote accepted

In Google Spreadsheets:

=count(unique(A2:C5))

answered Dec 12 '12 at 18:42

joseph4tw
1863

BillN · Answer 2 · 2012-12-12 16:37:09Z

up vote 2 down vote

The quickest way I can think of is to concatenate the three vaules into column D and do the CountUnique on Column D

answered Dec 12 '12 at 16:37

BillN
1213

migrated from superuser.com Dec 16 '12 at 9:06