hi matt,
try this...

=countif(A1:A50000,"yourtext")

works in xl2k. lookup countif in xl help.
Adjust the formula to fit your data.

regards

FSt1

"Matt Stone" wrote:

I need to count a number of text cells to find out if an exact same
occurance occurs more than twice.
I Use Excel 2003

Any ideas

Thanks