Why does this filter not work properly

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

Chris

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

---GJC

I get this error from your attachment.

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

"cj21" wrote:

>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> cj21
> ------------------------------------------------------------------------
> cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
> View this thread: http://www.excelforum.com/showthread...hreadid=527574
>
>

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


chris

ignore last post- bad grammar.

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


chris

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 in 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 & Paste Special/values over the data in I2 down. Note "'" is double quote-singlequote-double quote. This will ensure all data in the match list is text. If necessary, you can do the same with the data you are matching on as well.

---GJC

"Str8" <[email protected]> wrote in message
news:[email protected]...
>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...hreadid=527574

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


--
HTH

Sandy
[email protected]
[email protected] with @tiscali.co.uk

"Str8" <[email protected]> wrote in message
news:[email protected]...
>I get this error from your attachment.
>
> "Invalid Attachment specified. If you followed a valid link, please notify
> the administrator"
>
> "cj21" wrote:
>
>>
>> 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 |
>> +-------------------------------------------------------------------+
>>
>> --
>> cj21
>> ------------------------------------------------------------------------
>> cj21's Profile:
>> http://www.excelforum.com/member.php...o&userid=25673
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=527574
>>
>>