Piglet --

A B
1 Movie
2 Movie
3 Dog
4 Cat
5
6 =COUNTIF(A1:A4,"Movie")

Brings a result of 2.

HTH


"Piglet" wrote:

Need to found out the text eg Movie appeared how many times in a worksheet.
If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc