Finding words and neighbors using wildcards

  • Thread starter Thread starter Mary M
  • Start date Start date
M

Mary M

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
 
Hi Mary,

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

HTH
Carim
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find words and neighbors using wildcards 7
MS word Find and Replace using Regex - Help required 0
Copying data from many files 1
Word to Excel: Export comments with text and line number 0
Finding a value and returning corresponding info 3
How do I use the wildcard query to find words like "the" in the ta 2
Word Crashes when used with Excel and Windows Processes 0
Import cells from excel into word and create multiple word docs 2

Back
Top