poentially
=sumproduct(--(not(iserror(find("Account",A1:A1000)))))
will find the number of times a cell has the word "Account" in column A

"MarekZ" wrote:

Użytkownik bj napisał:
if the strings are in column A, in B1 enter
=countif(A:A,A1)
copy and paste down,
this will tell you how many times the each string will appear in a cell in
column A

if the string can be a part of a longer string, the answer is more complex,
do you need this?

"MarekZ" wrote:


Hi everybody,
I need some help. In worksheet I've column (one) with short strings. I
need to known how much times every of them repeats oneself. Somebody can
tell me is exists function which it will make this.

Thanks
Marek

Yes
Some strings looks like:

Account Data
Account information
Account not found
Account Type

Regards