If I understand what you want correctly, put this formula in a cell and copy
it down for 8 total rows...
=SUMPRODUCT(LEN(A$1:A$100)-LEN(SUBSTITUTE(A$1:A$100,ROW(A1),)))
Change the 100 in the A$100 (make sure to keep the $ signs) to a row number
that covers your range of interest. The first cell will show you a count of
the number 1, the second cell down will show you a count of the number 2,
and so on for the 8 digits you want to count.
--
Rick (MVP - Excel)
"Vermont Pete C" <Vermont Pete
wrote in message
...
I've got a range (one column) where each cell either
- has no value or number in it (empty cell)
- has 1 or more values in it (and I can separate by , ; - / or any other
symbol. )
Cells only have numbers, no text. Numbers are 1 to 8.
I would like to know how many occurances of each number happen in that
range.
Using count function does not work clearly (or any other count function).
For instance:
A1: 1,5
A2:
A3: 8
A4: 2,4,6,7,
etc...
Anyone knows if there is an existing function within excel or needs to be
macro (not my forté)?
Many thanks to the this community...
Peter C.