Custom filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the autofilter, and wish to Customise a data set in one of my columns.

A column has a listing of numbers 1-32. I wish to undertake a filtered selection of of only cells wish contain the numbers 1,2,3 & 7. How do I do this using the autofilter option? I have tried the 1-3,7 option but it didn't work w/ the 'contains' mode.

Can anyone advise? Thanks,
 
Unfrotunately Autofilter only allows for a limited number of criteria.

I appears that you now need to use advanced filter. That allows for a
lenghtier criteria lsit like 1, 2 ,3 , 7.
 
From the AutoFilter dropdown in the number column heading, choose Custom
In the first dropdown, choose 'is less than or equal to'
In the text box, type a 3
As a operator, choose Or
In the second dropdown, choose 'equals'
In the text box, type a 7
Click OK
 
Back
Top