Debra,
Thank you for your reply. I need to clearify my problem. My list has a
column of dates. I autofilter to a unique date the last recorded in the
filtered list is a different date and also the last record in the list. I
have discovered that the autofilter works correctly if the subtotal option is
turned off. I going to try this on another computer this evening to see if i
can duplicate it.
"Debra Dalgleish" wrote:
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