Thread
:
Please assist...
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Please assist...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett