Thanks Steve,
It's good to hear that your requirements are fulfilled.
Ankur, I have checked your formulation as well and it is good. Only two
things you need to watch here is if the locators i.e, 1a, 1b etc are not
coming at the end. But that's been not covered in the test data, so it's
good.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jan 26, 2010 at 5:28 PM, steve d <mck1...@gmail.com> wrote:
> No futher enhancements are necessary at this time you have fulfilled all of
> my requirements, quite remarkably Imight add, I appreciate everyone's
> efforts a great deal. I am looking forward to becoming a regular member of
> this group, as I have learned a great deal from you.
>
> Thanks again,
> Steve
>
>
> On Mon, Jan 25, 2010 at 1:38 AM, Dilip Pandey <dilipan...@gmail.com>wrote:
>
>> Dear Ankur,
>> Index Match is gud approach if there are more than 3 locators (1a, 1b,
>> 1c). I am not sure how Steve has the data setup n what is his further
>> req. are. I think he has only one column of data set alongwith 3
>> criterias.
>> Steve, pls let d group know if u still need more enhancements.
>> Ankur, right now i m mobile n not having Excel with me, so i will chk
>> your solution after few hrs.
>> Thx n regards,
>> DILIpandey
>>
>> On 1/25/10, ankur <ankurpande...@gmail.com> wrote:
>> > hi Dilip Sir & Steve
>> >
>> > if we have large data of similar basis, than we have to use different
>> > value in IF Function ,it will be very time consuming, i tried a
>> > approach please tell me is this is better or not
>> >
>> > =INDEX(A2:B4,MATCH("*"&D2&"*",A2:A4,0),2)
>> >
>> > plz check the attached file
>> >
>> > On 25/01/2010, Dilip Pandey <dilipan...@gmail.com> wrote:
>> >> Dear Steve,
>> >>
>> >> Assuming every time the code will start with 1 and this may appear
>> >> anywhere
>> >> in the text, you can use below formulae in next two columns after your
>> >> data,
>> >> respectively.
>> >>
>> >> =MID(A2,SEARCH(1,A2),2) =IF(C2="1a","Tampa, Fla.",IF(C2="1b","St.
>> >> Petersburg, Fla.","Dunedin, Fla."))
>> >>
>> >> Solved workbook is also attached with this email.
>> >>
>> >> Best Regards,
>> >> --
>> >> DILIP KUMAR PANDEY
>> >> MBA-HR,B COM(Hons.),BCA
>> >> Mobile: +91 9810929744
>> >> dilipan...@gmail.com
>> >> dilipan...@yahoo.com
>> >> New Delhi - 110062
>> >>
>> >>
>> >> On 1/25/10, Steve <mck1...@gmail.com> wrote:
>> >>>
>> >>>
>> >>> A B
>> >>>
>> >>> 1 ILLINOIS vs. IOWA 1a
>> >>> Tampa Fla.
>> >>>
>> >>> "1a" is a location code and is equal to Tampa Fla., Cell A1 contains
>> >>> the two competing teams plus "1a". I want to search for "1a" in A1
>> >>> and when it is found have excel return the location(Tampa Fla.) in a
>> >>> new cell (B1).
>> >>>
>> >>> This problem seems very easy, but i am having trouble getting exactly
>> >>> what i need.
>> >>>
>> >>> Thanks for the help,
>> >>> Steve
>> >>>
>> >>> --
>> >>>
>> >>>
>> ----------------------------------------------------------------------------------
>> >>> Some important links for excel users:
>> >>> 1. Follow us on TWITTER for tips tricks and links :
>> >>> http://twitter.com/exceldailytip
>> >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> >>> http://www.excelitems.com
>> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >>>
>> >>>
>> >>> To post to this group, send email to excel-macros@googlegroups.com
>> >>> If you find any spam message in the group, please send an email to:
>> >>> Ayush Jain @ jainayus...@gmail.com
>> >>> <><><><><><><><><><><><><><><><><><><><><><>
>> >>> HELP US GROW !!
>> >>>
>> >>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> >>> about
>> >>> the learning and support from the group.Let friends and co-workers
>> know
>> >>> they
>> >>> can subscribe to group at
>> >>> http://groups.google.com/group/excel-macros/subscribe
>> >>>
>> >>
>> >> --
>> >>
>> ----------------------------------------------------------------------------------
>> >> Some important links for excel users:
>> >> 1. Follow us on TWITTER for tips tricks and links :
>> >> http://twitter.com/exceldailytip
>> >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> >> http://www.excelitems.com
>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >>
>> >>
>> >> To post to this group, send email to excel-macros@googlegroups.com
>> >> If you find any spam message in the group, please send an email to:
>> >> Ayush Jain @ jainayus...@gmail.com
>> >> <><><><><><><><><><><><><><><><><><><><><><>
>> >> HELP US GROW !!
>> >>
>> >> We reach over 6,700 subscribers worldwide and receive many nice notes
>> >> about
>> >> the learning and support from the group.Let friends and co-workers know
>> >> they
>> >> can subscribe to group at
>> >> http://groups.google.com/group/excel-macros/subscribe
>> >>
>> >
>> >
>> > --
>> > Have A Nice Time & Enjoy Life
>> >
>> > Regards:
>> > CMA Ankur Pandey
>> > (Someone Different)
>> >
>> > I'm not the best but i'm not like the rest~~
>> >
>> > --
>> >
>> ----------------------------------------------------------------------------------
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> > http://www.excelitems.com
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> > If you find any spam message in the group, please send an email to:
>> > Ayush Jain @ jainayus...@gmail.com
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 6,700 subscribers worldwide and receive many nice notes
>> about
>> > the learning and support from the group.Let friends and co-workers know
>> they
>> > can subscribe to group at
>> > http://groups.google.com/group/excel-macros/subscribe
>> >
>>
>> --
>> Sent from my mobile device
>>
>> DILIP KUMAR PANDEY
>> MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 110062
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
