software

When I filter a spreadsheet I have, I ask for criteria in two columns.
Sometimes rows show up that do not meet that criteria i.e, column 1 - select
those with X; column 2 - select those with the category quot;abroadquot; - and some
items show up in the filter that do not have an X in the column. Why is that
- what do I need to do to get accurate information.
Cheri

Are you Paputxi???

If you apply your filter (filtering by that value--not just putting the arrows
in place) once more, look at the row numbers to the left.

The row numbers that are part of the autofilter range are blue. If the row
numbers are still gray, then they weren't part of your autofilter range.

Remove the filter arrows
Data|Filter|autofilter
then select your range--don't let excel guess
and reapply data|filter|autofilter

Then test it out.
Cheri wrote:
gt;
gt; When I filter a spreadsheet I have, I ask for criteria in two columns.
gt; Sometimes rows show up that do not meet that criteria i.e, column 1 - select
gt; those with X; column 2 - select those with the category quot;abroadquot; - and some
gt; items show up in the filter that do not have an X in the column. Why is that
gt; - what do I need to do to get accurate information.
gt; Cheri

--

Dave Peterson

Duh, I feel so dumb not thinking about the range. I should have known
better. Thank you - an no I'm not Paputxi.

Cheri

quot;Dave Petersonquot; wrote:

gt; Are you Paputxi???
gt;
gt; If you apply your filter (filtering by that value--not just putting the arrows
gt; in place) once more, look at the row numbers to the left.
gt;
gt; The row numbers that are part of the autofilter range are blue. If the row
gt; numbers are still gray, then they weren't part of your autofilter range.
gt;
gt; Remove the filter arrows
gt; Data|Filter|autofilter
gt; then select your range--don't let excel guess
gt; and reapply data|filter|autofilter
gt;
gt; Then test it out.
gt;
gt;
gt;
gt; Cheri wrote:
gt; gt;
gt; gt; When I filter a spreadsheet I have, I ask for criteria in two columns.
gt; gt; Sometimes rows show up that do not meet that criteria i.e, column 1 - select
gt; gt; those with X; column 2 - select those with the category quot;abroadquot; - and some
gt; gt; items show up in the filter that do not have an X in the column. Why is that
gt; gt; - what do I need to do to get accurate information.
gt; gt; Cheri
gt;
gt; --
gt;
gt; Dave Peterson
gt;

It was just surprising that there were similar questions within momemts of each
other.

Glad you got it working--even if you aren't Paputxi lt;vbggt;.

Cheri wrote:
gt;
gt; Duh, I feel so dumb not thinking about the range. I should have known
gt; better. Thank you - an no I'm not Paputxi.
gt;
gt; Cheri
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Are you Paputxi???
gt; gt;
gt; gt; If you apply your filter (filtering by that value--not just putting the arrows
gt; gt; in place) once more, look at the row numbers to the left.
gt; gt;
gt; gt; The row numbers that are part of the autofilter range are blue. If the row
gt; gt; numbers are still gray, then they weren't part of your autofilter range.
gt; gt;
gt; gt; Remove the filter arrows
gt; gt; Data|Filter|autofilter
gt; gt; then select your range--don't let excel guess
gt; gt; and reapply data|filter|autofilter
gt; gt;
gt; gt; Then test it out.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Cheri wrote:
gt; gt; gt;
gt; gt; gt; When I filter a spreadsheet I have, I ask for criteria in two columns.
gt; gt; gt; Sometimes rows show up that do not meet that criteria i.e, column 1 - select
gt; gt; gt; those with X; column 2 - select those with the category quot;abroadquot; - and some
gt; gt; gt; items show up in the filter that do not have an X in the column. Why is that
gt; gt; gt; - what do I need to do to get accurate information.
gt; gt; gt; Cheri
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson