AM I missing somethign here? The Custom filter I described earlier using the
'contains' feature will look for parts of a cell. It will find all cells in
that column that contain the word you look for(even if it contains more than
"pneumonia"), and display the entire row for the matching cells. So if you
want to just move the appropriate rows over one time ( or even a few), that
is a simple procedure to do it.

BlueDaze provided a procedure that will also work, but it requires you to
use a formula. This would be better if you wanted to have this happen more
autmatically, where you would be doing ti more freqently.

if we are missing the point, please provide the info in a different manner.

"shadesofsisyphus" wrote:


The issue with this is that it is not going to be the only word in that
cell so I cant sort by this or autofilter. I need something that will
select it out of a list in that one cell, there may be two or three
different things in that cell.I was thinking "*pneumonia*", or
something like that.


BlueDaze Wrote:
If you know only one record contains the word pneumonia and you want a
formula to do this, you can use wildcards in your forumula criteria.
For example, if you're using match of vlookup then you could write:
=match("*pneumonia*",range,0)
=vlookup("*pneumonia*",range,column,false)

* = any characters of unlimited length
? = any one character


--
BlueDaze


------------------------------------------------------------------------
BlueDaze's Profile:
http://www.excelforum.com/member.php...o&userid=27465
View this thread:
http://www.excelforum.com/showthread...hreadid=569560




--
shadesofsisyphus