Thread
:
find number of occurences of text within a column
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
external usenet poster
Posts: 10,593
find number of occurences of text within a column
=COUNTIF(H4:H108, "*RDS*")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"rob w" <rob
wrote in message
...
i want to count the number of cells in a column that contain the text
string
RDS. however there is also other text in the cells. i've tried
COUNTIF(H4:H108, "RDS"). but it returns 0 presumably as the cells contains
other text. how do i do this ? many thanks in advance.
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips