I bet you have a gap in your range (blank row???).

If you let excel guess what the range should be, it might guess wrong for you.

I'd remove the autofilter and then select the whole range and then apply
data|filter|Autofilter.



SueJB wrote:

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

--

Dave Peterson