There are a other instructions and examples in Excel's Help -- you might
find those useful. Also, if you can use code, there's a sample workbook
he

http://www.contextures.com/excelfiles.html#Filter

under the heading: Filter Rows for Text String

It uses an advanced filter, and event code, to filter a list for a text
string. You may be able to adapt this to your workbook.

You may be remembering the example in which the criteria is: ="=Ice"
to prevent the return of "Ice cream"

However, it sounds like your course numbers could be in any order in the
cell. One trainer might have: 3, 5, 12, 20
Another might have: 5, 20, 25
Those wouldn't work with the above criteria example.

Helen McClaine wrote:
"Debra Dalgleish" wrote:


And there may be better sources for direction than Contextures. What
information are you looking for?



I went to Contextures for a clearer understanding of how to use the Advanced
AutoFilter component. Which I think it did provide. However, if there's
something online that would provide better/clearer instruction and
explanation, I'm open to suggestions.

And thanks for the heads-up re potential problem on multiple returns because
of embedded numbers. I'll have a look at my categories and see if I can do
something to set apart the 1 from the 10. I believe I read something at
Contextures about a way to expressly identify a 10 vs a 1.

Helen





Helen McClaine wrote:

I'm creating a database of outside trainers. Each trainer can handle
multiple categories of training. It is essential that the training manager
be able to create lists for specific categories as the need arises, as well
as being able to do more standard sorts such as Name. Rather than making
multiple entries for each Trainer (one for each category, which may reach
10+), I'd like to allow multiple entries in the Category column utilizing a
key for each category.

It seems that AutoFilter would be the ideal method for creating this db.
Well, actually Advanced AutoFilter, since I'll need to be able to select for
a specified category key.

I've begun the research in how to use this feature, but before I go much
further I'd like to make sure I'm on the right path.

So -- would Advanced AutoFilter allow me to extract those records where a
search criteria is met?

-- would I use the criteria range formula Trainers!I3:I70="10" to
extract those records in Trainers where Column I contains the category key
"10"?

-- assuming the above is true, is there a better source for direction
than Contextures?


Thanks so much!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html