Posted to microsoft.public.excel.misc
|
|
Count cells containing specific text
Perfect. Thank you.
"Wigi" wrote:
Hi
=COUNTIF(YourRangeOfCells,"*shipped*")
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"dandiehl" wrote:
I have a column of free text cells that describe an action that was taken. I
would like to identify any cells that contain the word "shipped". (Shipped
will never be the only word in the cell, it is always part of a string of
text.)
|