Why does this filter not work properly

C

cj21

The filter stops working when products begin with 1. In otherwords it
only works for products that begin with a zero.

Chris


+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4542 |
+-------------------------------------------------------------------+
 
G

gjcase

Looks like your Match formula is working; there just aren't many item
in the match list which begin with 1. See row 578, it produces a matc
against 15091010

---GJ
 
S

Str8

I get this error from your attachment.

"Invalid Attachment specified. If you followed a valid link, please notify
the administrator"
 
C

cj21

It's not about matching products that begin with 1. All of the product
in the "exceptions" list beginning with a 0 match all th ones beginnin
with another number e.g 84 etc do not match. Hopefully this shosw m
problem.


chri
 
C

cj21

ignore last post- bad grammar.

It's not about matching products that begin with 1. All of the product
in the "exceptions" list beginning with a 0 match, all the one
beginning with another number e.g 84 etc do not match. Hopefully thi
shows my problem.


chri
 
G

gjcase

It appears you are caught in the text-vs-number mismatch dillemma (i.e.
text <> numbers.) To illustrate, go to cell I678 & add an apostrophe i
front of the number, making it text. H3124 will then return 677.

Ensure your data are all either numbers or text.

Suggest you put ="'"&I2 in J2 & copy down, then copy & Past
Special/values over the data in I2 down. Note "'" is doubl
quote-singlequote-double quote. This will ensure all data in the matc
list is text. If necessary, you can do the same with the data you ar
matching on as well.

---GJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top