Thanks for looking. I am very new to excel and have enroled on a course at work to improve my knowlegde but was wondering if someone could help me with what you will probably think is a really easy problem to solve.

I have a worksheet and want to know how to use excel to tell me how many times a specific word (eg BP01) appears so that it can be put into a chart.

So if some of the cells show:

BP01
BP02
BP03
BP01
BP01
BP02

I want it to tell me that there are 3 BP01's, 2 BP02's and 1 BP03.

Sorry about the way I've explained this, but as I said I am new to excel and havent picked up the "terminology" yet.