Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Why won't advanced filter return filter results?

I use advance filter a lot. For some reason, I cannot get it to return rows
based on criteria for column A, which is a number formatted to text. If I
choose to filter the invoice number three columns over it returns the
filtered rows just fine.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Why won't advanced filter return filter results?

What criteria are you using?
What is an example of the data you expect to be returned with that criteria?

jaws4518 wrote:
I use advance filter a lot. For some reason, I cannot get it to return rows
based on criteria for column A, which is a number formatted to text. If I
choose to filter the invoice number three columns over it returns the
filtered rows just fine.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Why won't advanced filter return filter results?

The criteria is just a single argument in the first column of the criteria
range. It is the a number formated as text. It is the "Store#" column. I have
never seen this before. I cannot say that I have ever specified criteria in
column 'A', which is the store number column in this case.

Anyway, it is not filtering based on the any on the following methods.

16
="=16"
*6

If I remove the criteria it returns all rows in the data list like it is
suppose too. If I go over and enter criteria in the invoice# column, it
returns all rows with that invoice number like it suppose too. Is there some
kind of first column rule that I'm not aware of?

I really think this has something to do with the data in this column being
formated to text. I converted it back to a number but that did not do
anything either.

"Debra Dalgleish" wrote:

What criteria are you using?
What is an example of the data you expect to be returned with that criteria?

jaws4518 wrote:
I use advance filter a lot. For some reason, I cannot get it to return rows
based on criteria for column A, which is a number formatted to text. If I
choose to filter the invoice number three columns over it returns the
filtered rows just fine.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Why won't advanced filter return filter results?

Did you use exactly the same heading in the criteria range as in the
Store# column? Maybe one has a space and the other doesn't.
That could prevent the filter from working as expected.

jaws4518 wrote:
The criteria is just a single argument in the first column of the criteria
range. It is the a number formated as text. It is the "Store#" column. I have
never seen this before. I cannot say that I have ever specified criteria in
column 'A', which is the store number column in this case.

Anyway, it is not filtering based on the any on the following methods.

16
="=16"
*6

If I remove the criteria it returns all rows in the data list like it is
suppose too. If I go over and enter criteria in the invoice# column, it
returns all rows with that invoice number like it suppose too. Is there some
kind of first column rule that I'm not aware of?

I really think this has something to do with the data in this column being
formated to text. I converted it back to a number but that did not do
anything either.

"Debra Dalgleish" wrote:


What criteria are you using?
What is an example of the data you expect to be returned with that criteria?

jaws4518 wrote:

I use advance filter a lot. For some reason, I cannot get it to return rows
based on criteria for column A, which is a number formatted to text. If I
choose to filter the invoice number three columns over it returns the
filtered rows just fine.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Why won't advanced filter return filter results?

That's it! I have spent hours on this. It just wasn't appearant that there
was a extra space.

Thank you Debra! I went to your web site before your first response. I will
go back again and browse through some of the examples. I am beginning a
project that will require me to use Excel, Access, & VBA for data analysis.
I'm sure I will talk to you in the near future.

"Debra Dalgleish" wrote:

Did you use exactly the same heading in the criteria range as in the
Store# column? Maybe one has a space and the other doesn't.
That could prevent the filter from working as expected.

jaws4518 wrote:
The criteria is just a single argument in the first column of the criteria
range. It is the a number formated as text. It is the "Store#" column. I have
never seen this before. I cannot say that I have ever specified criteria in
column 'A', which is the store number column in this case.

Anyway, it is not filtering based on the any on the following methods.

16
="=16"
*6

If I remove the criteria it returns all rows in the data list like it is
suppose too. If I go over and enter criteria in the invoice# column, it
returns all rows with that invoice number like it suppose too. Is there some
kind of first column rule that I'm not aware of?

I really think this has something to do with the data in this column being
formated to text. I converted it back to a number but that did not do
anything either.

"Debra Dalgleish" wrote:


What criteria are you using?
What is an example of the data you expect to be returned with that criteria?

jaws4518 wrote:

I use advance filter a lot. For some reason, I cannot get it to return rows
based on criteria for column A, which is a number formatted to text. If I
choose to filter the invoice number three columns over it returns the
filtered rows just fine.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Why won't advanced filter return filter results?

You're welcome! Thanks for letting me know that was the problem, and
good luck with your project.

jaws4518 wrote:
That's it! I have spent hours on this. It just wasn't appearant that there
was a extra space.

Thank you Debra! I went to your web site before your first response. I will
go back again and browse through some of the examples. I am beginning a
project that will require me to use Excel, Access, & VBA for data analysis.
I'm sure I will talk to you in the near future.

"Debra Dalgleish" wrote:


Did you use exactly the same heading in the criteria range as in the
Store# column? Maybe one has a space and the other doesn't.
That could prevent the filter from working as expected.

jaws4518 wrote:

The criteria is just a single argument in the first column of the criteria
range. It is the a number formated as text. It is the "Store#" column. I have
never seen this before. I cannot say that I have ever specified criteria in
column 'A', which is the store number column in this case.

Anyway, it is not filtering based on the any on the following methods.

16
="=16"
*6

If I remove the criteria it returns all rows in the data list like it is
suppose too. If I go over and enter criteria in the invoice# column, it
returns all rows with that invoice number like it suppose too. Is there some
kind of first column rule that I'm not aware of?

I really think this has something to do with the data in this column being
formated to text. I converted it back to a number but that did not do
anything either.

"Debra Dalgleish" wrote:



What criteria are you using?
What is an example of the data you expect to be returned with that criteria?

jaws4518 wrote:


I use advance filter a lot. For some reason, I cannot get it to return rows
based on criteria for column A, which is a number formatted to text. If I
choose to filter the invoice number three columns over it returns the
filtered rows just fine.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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 arcadhia Excel Discussion (Misc queries) 4 May 7th 06 11:35 PM
Problem using Advanced filter anandmr65 Excel Discussion (Misc queries) 1 April 17th 06 10:14 AM
advanced filter criteria "begins with" and "does not begin with" raph_baril Excel Worksheet Functions 3 June 28th 05 10:38 PM
Inconsistent Results: Advanced Filter Unique Records Only KB Excel Discussion (Misc queries) 1 March 25th 05 03:34 PM
Advanced Filter: No Filter Evan Weiner - Richalnd WA Excel Discussion (Misc queries) 2 December 9th 04 05:36 PM


All times are GMT +1. The time now is 02:42 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"