Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter including incorrect rows
Has anyone encountered a problem with Autofilter including rows that don't
meet the search criterion? The drop-down menu lists the correct choices, but the filter does not exclude all the rows that don't meet the chosen value. It's not a large sheet (c 250 rows) and the most it should return would be around 20-25 rows. Can anyone help? Thanks Sue |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter including incorrect rows
Either your filter ends before you expect it to.
or your data includes spaces at the end or the beginning so it doesn't meet the criteria for exclusion. But no, Autofilter is pretty robust. -- Regards, Tom Ogilvy "SueJB" wrote in message ... Has anyone encountered a problem with Autofilter including rows that don't meet the search criterion? The drop-down menu lists the correct choices, but the filter does not exclude all the rows that don't meet the chosen value. It's not a large sheet (c 250 rows) and the most it should return would be around 20-25 rows. Can anyone help? Thanks Sue |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter including incorrect rows
I bet you have a gap in your range (blank row???).
If you let excel guess what the range should be, it might guess wrong for you. I'd remove the autofilter and then select the whole range and then apply data|filter|Autofilter. SueJB wrote: Has anyone encountered a problem with Autofilter including rows that don't meet the search criterion? The drop-down menu lists the correct choices, but the filter does not exclude all the rows that don't meet the chosen value. It's not a large sheet (c 250 rows) and the most it should return would be around 20-25 rows. Can anyone help? Thanks Sue -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter including incorrect rows
Thanks Dave and Tom
No, there weren't any blank rows, but Dave's suggestion works so at least I don't have the problem now. I wish I knew what caused it though! Sue "Dave Peterson" wrote: I bet you have a gap in your range (blank row???). If you let excel guess what the range should be, it might guess wrong for you. I'd remove the autofilter and then select the whole range and then apply data|filter|Autofilter. SueJB wrote: Has anyone encountered a problem with Autofilter including rows that don't meet the search criterion? The drop-down menu lists the correct choices, but the filter does not exclude all the rows that don't meet the chosen value. It's not a large sheet (c 250 rows) and the most it should return would be around 20-25 rows. Can anyone help? Thanks Sue -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter Top 10 - Incorrect Answer | Excel Discussion (Misc queries) | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
Subtotals including blank rows | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |