If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"golden" wrote in message
...
Thank you Max but I have a bad habit of not explaining myself, sorry.
I have a worksheet and I'm trying to find word, computer, excel, work,
house, yard, study and I'm trying to make a graph of the hours I have
spent
in each item so I can figure out my study habits and this is for the last
year. So I need to find about a half a dozen word in about 400 rows. I
want
to put in all the words so I only have to go throw the spreadsheet once. I
don't know the how. I tried, commas, colons and a lot more but just don't
know and the help on office 2007 is not very good or I just don't know how
to
use it. Could you help me please.
Thank you

"Max" wrote:

Perhaps autofilter on a helper col will be potent enough?
Assume source data in A2 down
Assume your list of words to find is in F2:F5 ie: dog, cat, house, car
Put in B2: =COUNTIF($F$2:$F$5,A2)
Copy down to last row of source data. Col B returns 1 where the source
word
in col A is found in your list. Autofilter on col B, choose: 1. You got
it.
Aha? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"golden" wrote:
Find: dog, cat, house, car,
How do I do this?