If you have a Subtotal formula in the last row, it will be included when
you apply the AutoFilter, for any criteria.

R K Boles wrote:
I using a list Excel 2003 and when I autofilter it to view a unique value it
includes the last record in the list. Is this a known bug or am I doing
something wrong?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html