Creating a filtered list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenny Newbry - 02 Jul 2007 13:57 GMT

I am trying to filter a database and show only the records that match
certain criteria. For example, in column A I have employee business units.
I would like to be able filter that list somehow to show only those
employees in a particular business unit. I don't just want a count of
records that match, I want to show each matching record.

Reply to this Message

Bernie Deitrick - 02 Jul 2007 14:30 GMT

Kenny,

Select your table, then use Data / Filter.. Autofilter. Then in the drop down at the top of
column A, select the business unit of interest.

HTH,
Bernie
MS Excel MVP

>I am trying to filter a database and show only the records that match
> certain criteria. For example, in column A I have employee business units.
> I would like to be able filter that list somehow to show only those
> employees in a particular business unit. I don't just want a count of
> records that match, I want to show each matching record.

Reply to this Message

Rate this thread: