Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 +-------------------------------------------------------------------+ |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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does this filter not work properly
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: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=527574 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does this filter not work properly
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does this filter not work properly
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 -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=527574 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does this filter not work properly
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 -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=527574 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does this filter not work properly
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 -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=527574 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom filter does not work correctly | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
How do I make 'save as web page' with interactivity work properly. | Charts and Charting in Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions |