Ask Your Question

Counting how many times a certain number occurs in a list of cells in Libre Office Calc [closed]

asked 2014-08-10 07:05:52 +0100

MJK gravatar image

updated 2020-09-06 09:40:06 +0100

Alex Kemp gravatar image

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 :)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 22:18:53.907945

1 Answer

Sort by » oldest newest most voted

answered 2014-08-10 13:47:37 +0100

m.a.riosv gravatar image

updated 2014-08-10 13:48:34 +0100

Seems to me they are numbers as text not numbers, because the second one is beyond max number size, in spreadsheets.

Count numbers

Screenshot count numbers

edit flag offensive delete link more


Thanks you a lot! That is very smart :) It hels a lot !!!

MJK gravatar imageMJK ( 2014-08-11 08:53:46 +0100 )edit

Question Tools

1 follower


Asked: 2014-08-10 07:05:52 +0100

Seen: 1,262 times

Last updated: Aug 10 '14