Pls post in ONE group ONLY and ONE post only

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
One way would be with a helper column to filter on.
=LOOKUP(RIGHT(H2,2),{"00","34","67"},{1,2,3})
or
=LOOKUP(RIGHT(H6,2),{"00","34","67"},{"Jay","Bill" ,"Jim"})
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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