software

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: www.excelforum.com/attachment.php?postid=4542 |
-------------------------------------------------------------------

--
cj21
------------------------------------------------------------------------
cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
View this thread: www.excelforum.com/showthread...hreadid=527574
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--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=527574I get this error from your attachment.

quot;Invalid Attachment specified. If you followed a valid link, please notify
the administratorquot;

quot;cj21quot; wrote:

gt;
gt; The filter stops working when products begin with 1. In otherwords it
gt; only works for products that begin with a zero.
gt;
gt; Chris
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Book2.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4542 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; cj21
gt; ------------------------------------------------------------------------
gt; cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
gt; View this thread: www.excelforum.com/showthread...hreadid=527574
gt;
gt;


It's not about matching products that begin with 1. All of the products
in the quot;exceptionsquot; 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--
cj21
------------------------------------------------------------------------
cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
View this thread: www.excelforum.com/showthread...hreadid=527574
ignore last post- bad grammar.

It's not about matching products that begin with 1. All of the products
in the quot;exceptionsquot; 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--
cj21
------------------------------------------------------------------------
cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
View this thread: www.excelforum.com/showthread...hreadid=527574
It appears you are caught in the text-vs-number mismatch dillemma (i.e.,
text lt;gt; numbers.) To illustrate, go to cell I678 amp; 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 =quot;'quot;amp;I2 in J2 amp; copy down, then copy amp; Paste
Special/values over the data in I2 down. Note quot;'quot; 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--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=527574quot;Str8quot; gt; wrote in message
...
gt;I get this error from your attachment.
gt;
gt; quot;Invalid Attachment specified. If you followed a valid link, please notify
gt; the administratorquot;

Try following the

View this thread: www.excelforum.com/showthread...hreadid=527574

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

Sandy
with @tiscali.co.uk

quot;Str8quot; gt; wrote in message
...
gt;I get this error from your attachment.
gt;
gt; quot;Invalid Attachment specified. If you followed a valid link, please notify
gt; the administratorquot;
gt;
gt; quot;cj21quot; wrote:
gt;
gt;gt;
gt;gt; The filter stops working when products begin with 1. In otherwords it
gt;gt; only works for products that begin with a zero.
gt;gt;
gt;gt; Chris
gt;gt;
gt;gt;
gt;gt; -------------------------------------------------------------------
gt;gt; |Filename: Book2.zip |
gt;gt; |Download: www.excelforum.com/attachment.php?postid=4542 |
gt;gt; -------------------------------------------------------------------
gt;gt;
gt;gt; --
gt;gt; cj21
gt;gt; ------------------------------------------------------------------------
gt;gt; cj21's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=25673
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=527574
gt;gt;
gt;gt;