Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 11 Aug 2014 08:53:46 +0200Counting how many times a certain number occurs in a list of cells in Libre Office Calchttps://ask.libreoffice.org/en/question/38098/counting-how-many-times-a-certain-number-occurs-in-a-list-of-cells-in-libre-office-calc/I have a few cells that are filled with random numbers, eg:
cell A1: 3937376385699290
cell B1: 6568408355712890000
and I want Libre Office Calc to tell me how many 1's, 2's, 3's, 4's, etc are all together in those 10 or so cells.
So in the case of the above two cells, there are 1 1's, 2 2's, 5 3's, and so on
I tried COUNT and FIND but they didn't work
All help appreciated :)Sun, 10 Aug 2014 07:05:52 +0200https://ask.libreoffice.org/en/question/38098/counting-how-many-times-a-certain-number-occurs-in-a-list-of-cells-in-libre-office-calc/Answer by m.a.riosv for <p>I have a few cells that are filled with random numbers, eg: </p>
<p>cell A1: 3937376385699290</p>
<p>cell B1: 6568408355712890000</p>
<p>and I want Libre Office Calc to tell me how many 1's, 2's, 3's, 4's, etc are all together in those 10 or so cells.
So in the case of the above two cells, there are 1 1's, 2 2's, 5 3's, and so on</p>
<p>I tried COUNT and FIND but they didn't work</p>
<p>All help appreciated :)</p>
https://ask.libreoffice.org/en/question/38098/counting-how-many-times-a-certain-number-occurs-in-a-list-of-cells-in-libre-office-calc/?answer=38103#post-id-38103Seems to me they are numbers as text not numbers, because the second one is beyond max number size, in spreadsheets.
[Count numbers](/upfiles/14076713025040743.ods)
![Screenshot count numbers](/upfiles/140767081245424.png)Sun, 10 Aug 2014 13:47:37 +0200https://ask.libreoffice.org/en/question/38098/counting-how-many-times-a-certain-number-occurs-in-a-list-of-cells-in-libre-office-calc/?answer=38103#post-id-38103Comment by MJK for <p>Seems to me they are numbers as text not numbers, because the second one is beyond max number size, in spreadsheets.</p>
<p><a href="/upfiles/14076713025040743.ods">Count numbers</a></p>
<p><img alt="Screenshot count numbers" src="/upfiles/140767081245424.png"/></p>
https://ask.libreoffice.org/en/question/38098/counting-how-many-times-a-certain-number-occurs-in-a-list-of-cells-in-libre-office-calc/?comment=38132#post-id-38132Thanks you a lot! That is very smart :) It hels a lot !!!Mon, 11 Aug 2014 08:53:46 +0200https://ask.libreoffice.org/en/question/38098/counting-how-many-times-a-certain-number-occurs-in-a-list-of-cells-in-libre-office-calc/?comment=38132#post-id-38132