$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

2009-04-27 Thread Mayank Patel
Dear Aindril, Thanks for ur help, but this formula is not giving desired result. please try again. Thanks Again Regards Mayank Patel ITC LTD 9822978041 9422749110 On Tue, Apr 28, 2009 at 8:55 AM, Aindril De wrote: > Dear Mayank, > > You seemed to be almost on track with the formul

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

2009-04-27 Thread Mayank Patel
. Please revert back if u need some more information. Regards Mayank Patel ITC LTD 9822978041 9422749110 On Mon, Apr 27, 2009 at 9:39 PM, Ahmedhonest wrote: > Dear Fabio Lemos, > > I appreciate your solution to the Query but may i know the logic of this > formula how it works p

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

2009-04-27 Thread Mayank Patel
Hi Ashish, Can this ADD in be used with Excel 2000. If not do u have the one which can be used with Excel 2000 as i feel it is really helpful tool. and Thanks for sharing this ADD In with every one Regards Mayank Patel ITC LTD 9822978041 9422749110 On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

2009-04-27 Thread Mayank Patel
Hi Ashish, Can this ADD in be used with Excel 2000. If not do have the one which can be used eith Excel 2000 as i feel it is really helpful tool. and Thanks for sharing this ADD In with every one Regards Mayank Patel ITC LTD 9822978041 9422749110 On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain

$$Excel-Macros$$ !!URGENT!! Formula Required Please HELP

2009-04-27 Thread Mayank Patel
Dear Friends Please suggest the formula. sample file is attached. Thanks to all in Advance Regards Mayank Patel ITC LTD 9822978041 9422749110 --~--~-~--~~~---~--~~ - Some

$$Excel-Macros$$ Re: Any way to divide the cell for ex. by 1000 in its place

2009-04-19 Thread Mayank Patel
Thanks Ashish is there any other way than Macro I appreciate ur help. Regards Mayank Patel ITC LTD 9822978041 9422749110 On Sun, Apr 19, 2009 at 9:08 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Mayank, > > Try this VBA code. > 1. Select the cells and run the

$$Excel-Macros$$ Any way to divide the cell for ex. by 1000 in its place

2009-04-02 Thread Mayank Patel
re. if any one have >> example sheet please mail it to me. >> >> >> > > > > -- Regards Mayank Patel ITC LTD 9822978041 9422749110 --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Excel Formulas

2009-02-23 Thread Mayank Patel
Hi Dear, There is some problem with the Excel File Giving error that Data may have been lost. Can you send tht file again. Thanks Mayank On Mon, Feb 23, 2009 at 12:59 PM, b.pranab wrote: > Dear All, > > Best formula file ever seen, > > Wregards, > Pranab. > > > >

$$Excel-Macros$$ Can Anyone help to open the password protected DOC file.

2009-02-18 Thread Mayank Patel
Please Help -- Regards Mayank Patel ITC LTD 9822978041 9422749110 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit

$$Excel-Macros$$ Re: , is to .csv as ____ is to .xls

2008-12-19 Thread Mayank Patel
e where I can change the >> extension to .xls but then it puts all the info in one cell with , >> separating them. Does anyone know what the equivalent of , is for xls. >> is there there a symbol I can put instead of the , that would separate >> it into separate columns. >>

$$Excel-Macros$$ Re: Lookup for repetitive items

2008-10-24 Thread Mayank Patel
> The above problem is explained in the attached sheet. > > > > P.S. Would prefer an excel solution rather than a code. > > > > Pls help !!. > > > > Thanks, > > Nidhesh > > > > Vlookup_Rep_items.xls > > 31KViewDownload > > >

$$Excel-Macros$$ Re: Request for Formula

2008-10-20 Thread Mayank Patel
nd I Thanks each and every individual >> in advance for all your suggestions. >> >> Regards >> -- >> Ahmed Bawazir >> >> >> >> > > > -- > Thank You, > > Ajit Navre > > > > -- Regards Mayank Patel 9822978041 9422749110 --~--~-

$$Excel-Macros$$ Can I get Day from date in excel.

2008-10-14 Thread Mayank Patel
Hi friends, Is there any worksheet function to get the day like Monday, Tuesday etc. from any given date in excel. Regards Mayank --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send

$$Excel-Macros$$ Re: How to run the macro only if data available else stop.

2008-10-11 Thread Mayank Patel
re body of your macro within the following if, > Assume Main Tab is the active Tab. > > If Range("A65536").End(xlup).Row <> Range("J65536").End(xlup).Row then >' Place your existing macro here > EndIf > > Hope this was what you were looking for.

$$Excel-Macros$$ How to run the macro only if data available else stop.

2008-10-08 Thread Mayank Patel
ave a date in a1; in a2 I want to add 2 working days. >>> As per example: 3rd Oct, 2008 + 2 working days = 7th October, 2008 >>> >>> It will be a great help from u.!!! >>> >>> Thanks >>> >>> > > > -- > Thank Yo

$$Excel-Macros$$ Re: Excel Shortcuts

2008-09-13 Thread Mayank Patel
- > > *From:* excel-macros@googlegroups.com [mailto: > [EMAIL PROTECTED] *On Behalf Of *HP Reddy > *Sent:* Friday, September 12, 2008 1:56 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Excel Shortcuts > > > > Hi Everyone, >

$$Excel-Macros$$ Re: VBA - How to be a VBA programmer

2008-09-04 Thread Mayank Patel
some e-books and examles.. >> My e-mail id is [EMAIL PROTECTED] >> >> Thanks >> Sumesh >> >> >> -- Regards Mayank Patel 9822978041 9422749110 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-ma

$$Excel-Macros$$ Re: Vlookup Help

2008-08-31 Thread Mayank Patel
t; > > > > > >Thanks in advance . > > > > > > > >Rishi > > > > > > > > > > > >This Message was sent from Indian Oil Messaging Gateway. The information > contained in this electronic message and any attachments to t

$$Excel-Macros$$ Re: Thanks for help i need another help by you

2008-08-31 Thread Mayank Patel
eet is attached herewith... > > > > > On 8/30/08, yasir_shahjee <[EMAIL PROTECTED]> wrote: >> >> Dear palani >> >> I am member of $$Excle-macros$$ one time you was help me about trali >> detail >> >> Dear now i hve another problem i atta