Excluding a category from an autofilter

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

I have a spreadsheet set up with an autofilter on one of
the columns. There are 6 different types of values within
this column (say: a,b,c,d,e,f&g). It's easy enough to use
the filter to display any one of these categories
individually, but how do you set it to 'exclude' one of
the values (ie: only display values a,b,c,d,e&f, but
exclude g? - Thanks
 
Change the criteria to not equals.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top