Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how dose filter works to last cell in the column
some time fillter do not show existing cells
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use an if formula that works on a cell with column? | Excel Worksheet Functions | |||
Worksheet protected-auto filter works, show all button dosen't. | Excel Discussion (Misc queries) | |||
filter works on letters not numbers | Excel Discussion (Misc queries) | |||
excel file dose not open | Excel Discussion (Misc queries) | |||
options under tools dose not come up | Excel Worksheet Functions |