Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding words and neighbors using wildcards
Hi Mary,
Take a look at Data Autofilter ... it should give you all what you want ... HTH Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding different words in a cell | Excel Discussion (Misc queries) | |||
finding words in the cell | Excel Worksheet Functions | |||
Finding 2 or more words in excel | Excel Discussion (Misc queries) | |||
Finding Repeated Words | Excel Worksheet Functions | |||
Find words and neighbors using wildcards | Excel Programming |