Creating a filtered list

  • Thread starter Thread starter Kenny Newbry
  • Start date Start date
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.
 
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
 
Back
Top