Hey all,

I tried a search with no luck. I have a list of data that looks something like this:

A1=ABC_DEF_1
A2=ABC_DEF_2
A3=ABC_DEF_12
A4=ABC_DEF_1
ABC_DEF_2
ABC_DEF_12
.......

I need to find a formula that will count how many times in this colum ABC_DEF_1 occurs then how many times ABC_DEF_2 occurs.....etc

None of the formulas I have attempted seem to work completely. The formulas seem to pick up only some of the cells, but not all.

Thanks