Finding specific values within a string of numbers and/or lettersthat is always different

  • Thread starter Thread starter apg
  • Start date Start date
A

apg

Hi,

I wish to find specific information within the following string of
numbers that is always different. Here is an example of what I am
looking for:


Where to look:

*M|AA|YI|EA|EA|HE|IY|KJ|OH|P2|Q4|R<|T4|ZH|Z8|Z9|2U|7P|8(|9+


What I wish to find:

If there is an occurrence of "OH" then send to a new tab titled "OH"

Also just for fun, if there is an occurrence of T4 send to new tab
titled "T4"

and if there is an occurrence of YI send to new tab titled "YI"
 
Look at Find and Search in help, that should get you going.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Look at Find and Search in help, that should get you going.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)











- Show quoted text -
Click to expand...

Thank you Bob for a quick reply. I am using the following:
=MID(Z35,1,FIND("OH",U35,1)-1) Where the sting is in z35 and the name
of that item is in U35 first position. How do I then tell it in a
different tab if this condition exists then copy all the information
required. Such as customer name, address, phone, etc??? Would it be
easier to associate the results with a numeric value such as OH = 1 in
another column that I later hide and then in the required tab tell it
if 1 then OH Required? Does that make sense?
 
Thank you Bob for a quick reply. I am using the following:
=MID(Z35,1,FIND("OH",U35,1)-1) Where the sting is in z35 and the name
of that item is in U35 first position. How do I then tell it in a
different tab if this condition exists then copy all the information
required. Such as customer name, address, phone, etc??? Would it be
easier to associate the results with a numeric value such as OH = 1 in
another column that I later hide and then in the required tab tell it
if 1 then OH Required? Does that make sense?- Hide quoted text -

- Show quoted text -
Click to expand...

I am sorry, I have that backwards, the String value OH is located in
U35 and the name of that item is in Z35...
 
I thought that you did :-).

In that other tab use

=IF(ISNUMBER(FIND("OH",'Master'!Z35,1)),MID('Master'!U35,1,FIND("OH",'Master'!Z35,1)-1),"")



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I thought that you did :-).

In that other tab use

=IF(ISNUMBER(FIND("OH",'Master'!Z35,1)),MID('Master'!U35,1,FIND("OH",'Maste-r'!Z35,1)-1),"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)







- Show quoted text -
Click to expand...

Hey Bob, Thank you for that. The only problem that I am having with
that is when I enter the data it asks for a file to reference on my
computer...

The information that I am using is downloaded and it contains all the
information I need in an excel format. I am looking for specific
items that are an inventory back order issue and reassigning those
jobs to service stations that don't have an issue with those specific
items. So what I would like to do is have a sheet that the data is
placed into and with a macro I then sort it and identify those items
and make sure that they are not associated with a service provider
that has back order issues. The ones that I identify as a possible
issue I would like to pull from the data into another sheet
specifically for each item in question (in this case three items) and
pull all the customer information into that specific sheet. Once that
information is pulled from the "master" I would like to have it delete
the information from the master so that way it is clear for the next
days business management. There could be a little as 50 jobs per day
and as many as 1000 or more so it needs to be an adaptable thing.

I have toyed with the idea of creating a table with the differing
regions and service provider numbers and trying to work with a pivot
table.... But I have little experience with pivot tables...

Any suggestions on how to attack this? I have even thought of using
it to identity the service providers that have the issue would reduce
it to 2 or 3 providers but then I would like to adapt this into other
aspects to search out what jobs used what equipment ... down the
road ... maybe someday.

Thanks for your suggestions so far your help has been greatly
appreciated.

Jackie
 
I used a worksheet called Master. You will need to change that to whatever
you use.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top