are the word and number in separate cells or is a space and the number
concatenated onto the end of the word, all in one column. Is the column
column A or and all other columns are blank?

will base words always be 3 characters?

--
Regards,
Tom Ogilvy


"Mary M" wrote:


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: One
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 with 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

Thank you so much for your help!
~Mary M.


--
Mary M
------------------------------------------------------------------------
Mary M's Profile: http://www.excelforum.com/member.php...o&userid=32638
View this thread: http://www.excelforum.com/showthread...hreadid=524459