how dose filter works to last cell in the column

  • Thread starter Thread starter Khalid
  • Start date Start date
A filter only calculates to the next empty Cell. So if there is an empty cell
in the column it will not go to last cell.

Hope this helps.
 
I never let excel guess at the range to filter. I always select the range I
want, then apply the filter.

Maybe you could try removing the filter, reselecting the range, reapplying the
filter and then filter once more.

If that doesn't help, you'll have to add more details -- what you're filtering
text (including length of text), dates, times
how you're filtering (contains, greater, equal...)
and how it fails.
 
Back
Top