[SOLVED]Addiitonal question on Countif - number occurrences in one cell

I'm very new to excel infact this is my first time using formulas.


Sample Data :

A Column

A1 = 01-03-22
A2 = 99-100-22
A3 = 22-100-200

I need to have an output counting the occurrences of the all numbers like the results below.

22 = 3
100 = 2
..
...
...

anyone have an idea on what formula to count it ?


My problem was partially solved by this formula but I realize I needd to convert the existing data to something like A1 = 01 B1 = 03 C1 = 22 which is one number per cell if I'm going to stick with the formula below.

=COUNTIF(range:range, criteriarange:criteriarange)

thank you

if your entries are always consistent, as shown - numbers - numbers - numbers, you can use these formulas to break them up into 3 cells (B1, C1, D1) for the count...

in B1 =left(A1,2) (if this could contain more than a 2 digit number, use =LEFT(A2,FIND("-",A2,1)-1)
in C1 =MID(A1,FIND("-",A1,1)+1,FIND("-",A1,FIND("-",A1,1)+1)-1-FIND("-",A1,1))
in D1 =RIGHT(A1,LEN(A1)-FIND("-",A1,FIND("-",A1,1)+1))
if you need the answer to be an actual number instead of text, use =value(above-formula)

let me know how you make out?

ok, have you tried text-to-columns? use the "-" as the criteris, and then (if needed), delete the columns with "-"

great that you worked it out for yourself, and glad i could help. thx for the star too