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 +0200

MJK gravatar image

updated 2014-08-10 07:07:12 +0200

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 +0200

m.a.riosv gravatar image

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

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 +0200 )edit

Question Tools

1 follower


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

Seen: 762 times

Last updated: Aug 10 '14