"Find All"
 

When I want to find all instances of a particular item in an Excel database
and I use the "Find All" option what I get is a window with columns Book,
Sheet, Name, Cell, Value & Formula. For example; In a music database I keep
with the columns Artist, Title & Disc and I searched on "Motown", what I want
to get back would be all the tracks of all the artists on a disc with
"Motown" in the title. But what I get is the name of the database in the
"Book" column, the sheet the database is on in the "Sheet" column, nothing in
the "Name" column, the cell the word "Motown" appears in in the "Cell"
column. How do I get a list that doesn't only show a list of cells the
search word appears in.

An alternative to using Edit|find|all.

Try applying Data|filter|autofilter to your range.

Then you can filter by any column. Use the dropdown and select Custom. Then
use Contains in the next dialog.

Then data|filter|showall to see everything.



DavidB wrote:

When I want to find all instances of a particular item in an Excel database
and I use the "Find All" option what I get is a window with columns Book,
Sheet, Name, Cell, Value & Formula. For example; In a music database I keep
with the columns Artist, Title & Disc and I searched on "Motown", what I want
to get back would be all the tracks of all the artists on a disc with
"Motown" in the title. But what I get is the name of the database in the
"Book" column, the sheet the database is on in the "Sheet" column, nothing in
the "Name" column, the cell the word "Motown" appears in in the "Cell"
column. How do I get a list that doesn't only show a list of cells the
search word appears in.

--

Dave Peterson