Why does this filter not work properly

[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 |
+-------------------------------------------------------------------+

 

[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

 

[Str8]

I get this error from your attachment.

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

 

[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

 

[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

 

[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

 

[Sandy Mann]

I get this error from your attachment.

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

Try following the

View this thread: http://www.excelforum.com/showthread.php?threadid=527574

link and then opening the attachment from the post in ExcelForum.


--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk