how dose filter works to last cell in the column
 

some time fillter do not show existing cells

how dose filter works to last cell in the column
 

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.

"Khalid" wrote:

some time fillter do not show existing cells

how dose filter works to last cell in the column
 

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.

Khalid wrote:

some time fillter do not show existing cells

--

Dave Peterson