Is there a way to count a sequence of data as long as they are similar? We have a datasheet were the sales of our sales men are imported. One of the information we’re using is counting for how long one sales man has been on top.
Ex.: Sales man#1 Sales man#1 Sales man#1 Sales man#2 Sales man#1 Sales man#3 Is here a way that calc can detect that the data is changing and stop the counting? The above sample should return 3 Looking forward to any suggestion. -- View this message in context: http://nabble.documentfoundation.org/Calc-Count-a-similar-sequence-tp4185391.html Sent from the Users mailing list archive at Nabble.com. -- 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
