how to "find all" in a column?

[yennta]

I operate on a "need to know" basis which leaves me very stupid at
times.
I'm making a list of words in a column. These words represent media on
multiple drives. There are duplications. I would like to be able
easily to find all instances of a particular word (or piece of media).
When I do a find I am only permitted by excel to find one at a time. I
need to find all and separate them from the other words so I can
investigate them. I've tried to make a "list" using "list manager" but
I can't understand how it works. I mean, I read the instructions but
don't understand them. If a list is what I need to do a "find all" is
there a tutorial somewhere that will walk me through creating one?

 

[JE McGimpsey]

I operate on a "need to know" basis which leaves me very stupid at
times.
I'm making a list of words in a column. These words represent media on
multiple drives. There are duplications. I would like to be able
easily to find all instances of a particular word (or piece of media).
When I do a find I am only permitted by excel to find one at a time. I
need to find all and separate them from the other words so I can
investigate them. I've tried to make a "list" using "list manager" but
I can't understand how it works. I mean, I read the instructions but
don't understand them. If a list is what I need to do a "find all" is
there a tutorial somewhere that will walk me through creating one?

This may help:

http://cpearson.com/excel/duplicat.htm

 

[yennta]

Thanks, much. That info is too complicated for me. I guess I need
some very basic training in Excel. Even the term "array" freaks me
out. Fortunately, I stumbled on an easier answer myself. I import the
excel columns as fields into Filemaker, so that each line of the column
is a record and each additional line in each additionala column is a
field in in the record. Once in Filemaker, any kind of search is a
breeze.