• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

Can you filter on 10 separate items in a column in Excel 2007?

Hi Guys, is there a way you can filter on 10 separate items in a column in an Excel 20007 spreadsheet?
0
Justincut
Asked:
Justincut
1 Solution
 
bbaoIT ConsultantCommented:
the details are here:

"How to add a filter in Excel 2007"
http://www.wikihow.com/Add-a-Filter-in-Excel-2007
0
 
Swapnil NirmalCommented:
see this video and your doubts would be clear:

How to filter data in Excel, by Michelle Mangen
www.youtube.com/watch?v=EF9a5XuOu2w¿
0
 
byundtCommented:
If you want to filter 10 items using VBA code, the trick is to list them in an array. In the snippet below, for example, I am filtering cells containing the first 10 letters of the alphabet:
Sub Filter10()
Range("A1").AutoFilter      'Turn off any existing filters
Range("$M$1:$M$13").AutoFilter Field:=1, Criteria1:=Array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j"), Operator:=xlFilterValues
End Sub

Open in new window

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now