You could use the Custom option in an AutoFilter to find records that
contain a 10.

Or, you could use an Advanced Filter, with the Column I heading, and the
criteria: *10

However, you may encounter problems with either technique if your course
numbers are similar. For example, filtering for *5 would return 1, 15,
25, 50, etc. You might be able to work around this by adding a text
character at the start and end of each course number.

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

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