Filter does not work
 

check out the attachment. This is an example of my huge dataset. I want
to filter the records so that only numbers with 2 digits appear. To do
this i go filter, custom, equals ??. And it does not show the results!
Why

Chris


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4549 |
+-------------------------------------------------------------------+

--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=528061

Filter does not work
 

Hi

Set the Criteria to
Greater than 9
and
Less than 100

--
Regards

Roger Govier


"cj21" wrote in
message ...

check out the attachment. This is an example of my huge dataset. I
want
to filter the records so that only numbers with 2 digits appear. To do
this i go filter, custom, equals ??. And it does not show the results!
Why

Chris


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4549 |
+-------------------------------------------------------------------+

--
cj21
------------------------------------------------------------------------
cj21's Profile:
http://www.excelforum.com/member.php...o&userid=25673
View this thread:
http://www.excelforum.com/showthread...hreadid=528061

Filter does not work
 

I cant do that. In reality my dataset is huge. I have lots of product
codes ranging from 2 digit to 6-digit and some of them begin with a
zero which is even more problematic. I just need to filter all of the
2-digit codes.

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=528061

Filter does not work
 

Hi

I don't see why not.
If the data is numeric, then greater than 9 and less than 100 will give
any value between 10 and 99 inclusive, i.e. all 2 digit regardless of
the total size of any numbers.

If the values are text, then equals ?? will produce the desired result.

Your explanation, and sample posted show the latter not to be true, and
in my tests at least, with values extending up to 6 digit numbers, then
what I posted appears to produce the correct results

--
Regards

Roger Govier


"cj21" wrote in
message ...

I cant do that. In reality my dataset is huge. I have lots of product
codes ranging from 2 digit to 6-digit and some of them begin with a
zero which is even more problematic. I just need to filter all of the
2-digit codes.

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile:
http://www.excelforum.com/member.php...o&userid=25673
View this thread:
http://www.excelforum.com/showthread...hreadid=528061