Am 07.11.2015 um 17:44 schrieb Robert Peirce: > I have two columns of data, A and B. Sometimes A.n>B.n, A.n<B.n or > A.n=B.n. I want to count these occurrences. The closest I could find > in help was countif(), but that doesn't really do what I need. Any ideas? > >
X1: =SIGN(A1-B1) copy down =COUNTIF(X1:X999;0) =COUNTIF(X1:X999;1) =COUNTIF(X1:X999;-1) or use FREQUENCY with column X or create a pivot table from column X -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
