Hi K,

I would suggest that you try the Advanced Filter option.

Debra Dalgleish has a good tutorial on using complex criteria at:

http://www.contextures.com/xladvfilter02.html

---
Regards,
Norman



"thorvision" wrote
in message ...

I have a 1000 row/15 column Excel database. One of the fields is
"Project Description" where it decribes the nature of a capital
project. I'm looking to find all records relating to "Fire and
Security" which could include words such as "safety", "sprinkler",
"Upgrade" "Fire" all within the Project Description field. I need to
be able to pull all those records. How do I perhaps use Excel's
advance filter feature to perform this search for what I may refer to
as key words. Or, is there a worksheet function I can use to do the
same. Thanks.




--
thorvision

chess
------------------------------------------------------------------------
thorvision's Profile:
http://www.excelforum.com/member.php...fo&userid=1778
View this thread: http://www.excelforum.com/showthread...hreadid=489346