Ask Your Question

How to count unique values in a column?

asked 2017-03-05 12:50:36 +0200

dmhowcroft gravatar image

Is there a built in function where I can specify a range of cells and get the number of unique values in those cells? For example, something like:


Or perhaps a function which returns the unique values so that I could then COUNT them?

I've already looked at this answer, but it looks like the solution to a much more difficult question.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-05 13:12:09 +0200

karolus gravatar image


=SUM( 1 / COUNTIF( A2:A34 ; A2:A34 ) )

entered as Array-formula with keys: <ctrl>+<shift>+<enter>

edit flag offensive delete link more



With this formula I get "Div/0".

Also, could you explain the rationale behind it? How is would be supposed to work?

Thank You!

VeganGio gravatar imageVeganGio ( 2017-04-28 08:52:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-05 12:50:36 +0200

Seen: 9,991 times

Last updated: Mar 05 '17