COUNTIF for single word in text
How can i COUNTIF for the word "travel" in a cell which reads, "travel status
thru 6-1-07" or the like? thanks! |
COUNTIF for single word in text
There are a few ways to do this. Here is the most generic way for a range of
cells: =COUNTIF(A1:A10,"*travel*") Biff "jewelybrook" wrote in message ... How can i COUNTIF for the word "travel" in a cell which reads, "travel status thru 6-1-07" or the like? thanks! |
COUNTIF for single word in text
=COUNTIF(A:A,"*travel*")
"jewelybrook" wrote: How can i COUNTIF for the word "travel" in a cell which reads, "travel status thru 6-1-07" or the like? thanks! |
COUNTIF for single word in text
thank ya'll!
"T. Valko" wrote: There are a few ways to do this. Here is the most generic way for a range of cells: =COUNTIF(A1:A10,"*travel*") Biff "jewelybrook" wrote in message ... How can i COUNTIF for the word "travel" in a cell which reads, "travel status thru 6-1-07" or the like? thanks! |
All times are GMT +1. The time now is 03:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com