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?
JustincutAsked:
Who is Participating?
 
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
 
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 NirmalManager, Audit AnalyticsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.