Creating a filtered list

K

Kenny Newbry

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.
 
B

Bernie Deitrick

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
 
Top