Autofilter Wildcards Not Working on Number Column

[soke2001]

(((sorry, re-posting same message because I messed up the title on the
other))

Hello everyone...n00b question.

I'm using Excel 2003 to split up a daily spreadsheet between me and 2
of my peers. We split the orders based on the last 2 characters of the
order. The orders are all 7 digits and all numerical. Exp... 3215453.
For example... my number range is 00-33.

Every morning I have to scroll through the spreadsheet and manually
select my orders to obtain my daily workload, which can take up to 40
minutes. I tried using auto-filter with wildcards * & ?, but they
don't work. I'm typing my custom filter values as follows ?????33 and
*33, but they don't work. Are they supposed to work on numbers?

There has to be an easier way... please assist.

Thanks in advance!!

Javier Cortes

 

[Ron Coderre]

With Col_A containing order numbers,
and A1: Order

Try using a "helper column"
B1: Group

This formula will return
1 for items ending in 00-33
2 for items ending in 34-66
3 for items ending in 67-99

B2: =MAX(CEILING(MOD(A2,100)/33,1),1)
Copy B2 down as far as you need

Then use AutoFilter to select items from your group.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Guest]

Hi,

See my answer on your other post.

Regards,

OssieMac