Hi Rahul,
Thanks for the title, but let me convey the message that I am not Master and
I am also learning with all the members like you.
Though you have used many "Names" in the spreadsheet, which is time
consuming on one front, but that's ok. It is 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 1/19/10, Rahul Gandhi <myname.ra...@gmail.com> wrote:
>
> Hey Dilip,
>
> I took your formula as a Base and try to use the same parameters as
> discussed on the call. But, you are the Master.
>
> Dear, request you to please have a look to the file and let me know is
> there any mistake or not. ??
>
> Dude wat all I am trying to say is I Got my results i.e. more than enough
> for me atleast.
>
>
> Regards,
> Rahul Gandhi
> 9711772297
>
>
>
> On Tue, Jan 19, 2010 at 2:58 PM, Dilip Pandey <dilipan...@gmail.com>wrote:
>
>> Hi Rahul,
>>
>> Considering the following points, below is the formula designed to cater
>> them all.
>>
>> 1) There may be digit 9 which can come earlier also.
>> 2) There may by spaces and periods after "A/C No."
>>
>> =MID(MID(C7,FIND("A/c",C7),30),FIND(9,MID(C7,FIND("A/c",C7),30)),10)
>>
>> Above formula assumes that text is entered in cell C7.
>>
>> Solved workbook is also attached.
>>
>> 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 19, 2010 at 12:17 AM, Rahul Gandhi. <myname.ra...@gmail.com
>> > wrote:
>>
>>> Guys,
>>>
>>> I am facing some problem to Extract the A/c no. from Line written in
>>> Particular Cell.
>>>
>>> There is only 2 Unique things
>>>
>>> 1. A/c No. should be starts from 9.
>>> 2. Length of A/c no. is 10 digits.
>>>
>>> Example.
>>>
>>> A1 = EMI of Rs. 800 From A/c No. 9089655463
>>> A2 = From A/c No. 9826438564 Debt EMI 300
>>> A3 = Ac No 9658489652 EMI Amt 200
>>>
>>>
>>> Friends I have 8 Files Consisting 200 Sheets Each and Each Sheet
>>> Consists around 20000 to 30000 Rows of Data with the same type of
>>> Entry.
>>>
>>>
>>> Can any one please help me out to extract the data.
>>>
>>> Regards
>>> Rahul Gandhi.
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> 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
