View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Autofilter including incorrect rows

Either your filter ends before you expect it to.

or your data includes spaces at the end or the beginning so it doesn't meet
the criteria for exclusion.

But no, Autofilter is pretty robust.

--
Regards,
Tom Ogilvy

"SueJB" wrote in message
...
Has anyone encountered a problem with Autofilter including rows that don't
meet the search criterion?

The drop-down menu lists the correct choices, but the filter does not
exclude all the rows that don't meet the chosen value.

It's not a large sheet (c 250 rows) and the most it should return would be
around 20-25 rows.

Can anyone help?

Thanks
Sue