AutoFilter

  • Thread starter Thread starter Sheri
  • Start date Start date
S

Sheri

Thanks for the help. I am using Excel XP. I have a list of
items that come from an Oracle Database. They are vehicle
numbers that begin with a 0. (028,034,039,056, etc) I
have an autofilter and want to filter out numbers >= 028
and <= 039. I always get an empty set returned to me. I
assume this is because these are text items rather than
numbers. Is there a way to accomplish this filter with
text?
 
Hmmm, not really sure if this is what you mean but have
you tried puting a ' infront of the number, it denotes it
as text. (It is under the " key)
 
No. That's the problem, these are text items and they
won't filter the way I need them to.
 
One way?

Assume the vehicle numbers are in col A, A2 down

Insert a new helper col next to it, say col B

Put in B2: =VALUE(A2)
(this converts the text in col A to numbers)

Now, you can autofilter on col B
--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email
-------------------------------------------
 
oops, missed out a line...
Put in B2: =VALUE(A2)
(this converts the text in col A to numbers)
Click to expand...

should read:
Put in B2: =VALUE(A2)
copy B2 down col B
(this converts the text in col A to numbers)
Click to expand...
--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email
-------------------------------------------
 
Back
Top