Re: Count function

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 work*** 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
.

Quantcast