Finding words and neighbors using wildcards
 

Hi everyone,

I've got a thesis riding on this, so any help would be _REALLY
appreciated! :)

I've got some experimental data in an Excel file with two columns: On
with words and one with numbers.

What I want to do is to save all the words for which their number is
100, *AND* for which there exists -word*- (ie: the original word wit
any arbitrary letters following it) with a number < 50.

So for instance, if I have

abc 65
abcd 32
pqr 105
xyz 101
xyza 45
xyzbc 35


I would like an output (anywhere) which shows

xyz 101
xyza 45
xyzbc 35

My knowledge of excel programming is really pretty basic.
Thank you so much for your help!
~Mary M

--
Mary
-----------------------------------------------------------------------
Mary M's Profile: http://www.excelforum.com/member.php...fo&userid=3263
View this thread: http://www.excelforum.com/showthread.php?threadid=52446

Finding words and neighbors using wildcards
 

Hi Mary,

Take a look at Data Autofilter ...
it should give you all what you want ...

HTH
Carim