Text repeats
Posted by Steve on December 28, 2000 5:49 AM
How can I find out how many times a text string occurs in a column or area? Eg. "Holiday" appears in column A 10 times etc....
ta very much helper!
Posted by Aladin Akyurek on December 28, 2000 6:25 AM
If col A contains the data, use in (e.g.,) B1:
=COUNTIF(A:A,A1) [ copy this down as far as needed ]
to get a count of any value, including "Holiday" if that exists.
Aladin
Posted by Aladin Akyurek on December 28, 2000 6:43 AM
If col A contains the data, use in (e.g.,) B1:
=COUNTIF(A:A,A1) [ copy this down as far as needed ]
to get a count of any value, including "Holiday" if that exists.
Aladin
