2015-09-08

EXCEL - Count unique values in range

={ SUM( 1 / COUNTIF( A1:A100, A1:A100 ) ) }

PS. For this to work, the range (e.g. A1:A100) can not contain blank cells.
PSS. This is an array function... press CTRL+ENTER once written for it to work.

By

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)