bcoughlan/countduplicates

Created July 2, 2012 02:09

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bcoughlan/3030514.js"></script>
Save bcoughlan/3030514 to your computer and use it in GitHub Desktop.

Download ZIP

OpenOffice calc - count duplicates

Raw

countduplicates

=COUNTA(A2:A23)-SUMPRODUCT((A2:A23<>"")/(COUNTIF(A2:A23,A2:A23)+(A2:A23="")))

stiegenaufgang commented Aug 27, 2014

At first, thanks for this great snippet.
I tried it with Apache OpenOffice 4.0.1 and it only worked after changing the comma in the COUNTIF function to a semicolon.

=COUNTA(A2:A23)-SUMPRODUCT((A2:A23<>"")/(COUNTIF(A2:A23;A2:A23)+(A2:A23="")))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment