MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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