View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
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