rogue rows appear in autofiltered sort

D

dmich

When I perform an autofilter on a column one row keeps appearing at the
bottom even though it doesen't fit the autofilter criteria. I have deleted
and cleared contents in the row thinking there was something there that I
wasn't seeing but the problem persists.
 
T

T. Valko

I've experienced this before when:

I used a formula to sequentially number the filtered rows *and* the column
with this formula is included in the filtered table. For example:

A3:An contains this formula: =SUBTOTAL(3,B$3:B3)
B3:Kn is the table data

If column A is included in the filter area you will get what you've
described. The solution was to set the filter only on the table data in B:K.
 
Top