Thread: [Solved] AutoFilter Criteria3
View Single Post
 
Old 01-17-2013, 02:24 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
If you need more than 2 criteria on the same column then your immediate choices are:
  • Use a helper column
  • Use the advanced filter instead of an autofilter. Using the advanced filter will require a criteria range to be set up.
Reply With Quote