hi dilip sir
thanks for your words
On 26/01/2010, Dilip Pandey <dilipan...@gmail.com> wrote:
> 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
>
--
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
