"Josh Craig" wrote:
.. One other thing though, can I modify that formula to give me results in
column B that show all from column A NOT containing "dog"?

Just slightly adjust* the criteria formula in C1 to:
=IF(ISNUMBER(SEARCH("Dog",A1)),"",ROW())
then copy C1 down

[swap the IF_TRUE/IF_FALSE values around]

(no change to the formulas in col B)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---