Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Advanced Filter - filter rows <

Why does using the < operator work for filter criteria one column but not in
another? It does not filter out the rows in my "Store Number" column.

Example: The following does not work...

Store
<4

This works...
Location
<Outdoor

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Advanced Filter - filter rows <

Hi

Maybe your store numbers are really text
Try
Store
<"4"

--
Regards

Roger Govier


"jaws4518" wrote in message
...
Why does using the < operator work for filter criteria one column but
not in
another? It does not filter out the rows in my "Store Number" column.

Example: The following does not work...

Store
<4

This works...
Location
<Outdoor



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Advanced Filter - filter rows <

I have tried text and number formats. If my value is formatted as a number
then <4 should return all row except for those with 4. Here is what I do
know...

I added a character to my number #4 and it filters fine. The not equal
operator is not filtering a number regarless of the format. It does seem to
work with the other operators.
,<,=



"Roger Govier" wrote:

Hi

Maybe your store numbers are really text
Try
Store
<"4"

--
Regards

Roger Govier


"jaws4518" wrote in message
...
Why does using the < operator work for filter criteria one column but
not in
another? It does not filter out the rows in my "Store Number" column.

Example: The following does not work...

Store
<4

This works...
Location
<Outdoor




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Advanced Filter - filter rows <

Hi

There is no inherent reason why <4 should not work. It works fine on
all applications where I use Advanced Filter.
I would still suspect the data in the Store column.
In a separate column on that sheet, enter =LEN(A2) and copy down, having
substituted A2 with the cell number of your first store value.
Does the result come to 1 for stores with a supposed value of 4?
If not there may be leading or trailing spaces (Char(32), or the
non-breaking space character (char(160).
If you find the length is greater than expected, try entering in another
column
=SUBSTITUTE(SUBSTITUTE(A2,Char(160),"")," ","")
and copy down.
Copy this new data and Paste SpecialValues back over the data in your
Store column and see if the advanced filter works then.
--
Regards

Roger Govier


"jaws4518" wrote in message
...
I have tried text and number formats. If my value is formatted as a
number
then <4 should return all row except for those with 4. Here is what I
do
know...

I added a character to my number #4 and it filters fine. The not equal
operator is not filtering a number regarless of the format. It does
seem to
work with the other operators.
,<,=



"Roger Govier" wrote:

Hi

Maybe your store numbers are really text
Try
Store
<"4"

--
Regards

Roger Govier


"jaws4518" wrote in message
...
Why does using the < operator work for filter criteria one column
but
not in
another? It does not filter out the rows in my "Store Number"
column.

Example: The following does not work...

Store
<4

This works...
Location
<Outdoor






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Filter not working babypenquin Excel Worksheet Functions 1 June 22nd 06 05:48 PM
Advanced Filter anandmr65 Excel Discussion (Misc queries) 5 June 5th 06 07:30 AM
Problem using Advanced filter anandmr65 Excel Discussion (Misc queries) 1 April 17th 06 10:14 AM
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
Using advanced filter to search for criteria in a list Potatosalad2 Excel Discussion (Misc queries) 1 June 8th 05 03:08 AM


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"