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
Carim - 20 Mar 2006 18:21 GMT
Hi Mary,
Take a look at Data Autofilter ...
it should give you all what you want ...
HTH
Carim