Thread
:
find number of occurences of text within a column
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
rob w[_2_]
external usenet poster
Posts: 1
find number of occurences of text within a column
great that works! many thanks.... rob
"Bob Phillips" wrote:
=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
rob w[_2_]
View Public Profile
Find all posts by rob w[_2_]