(((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

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)


"soke2001" wrote in message
ups.com...
(((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

Hi,

See my answer on your other post.

Regards,

OssieMac

"soke2001" wrote:

(((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