$$Excel-Macros$$ IRR & Cash Flows

2011-11-25 Thread NewToThisGroup
Hello. Column A, Column B Date 1, CashFlow 1 Date 2, Cash Flow 2 Date 3, Cas Flow X I want to solve for Cash Flow X so that it gives me a number such that the stream of cash flows (and the associated dates) results in a 10% return (using the XIRR function)? Is there a forumla that I can enter int

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-25 Thread kJo
What address or contact number pls? Any where in Borivli ? On Nov 24, 2:07 pm, krishnanm2...@gmail.com wrote: > Andheri east > > Sent on my BlackBerry® from Vodafone > > > > > > > > -Original Message- > From: mangesh bavalekar > > Sender:excel-macros@googlegroups.com > Date: Thu, 24 Nov

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-25 Thread kJo
Gr8.. On Nov 25, 10:51 am, NOORAIN ANSARI wrote: > Dear Krishnann, > > Press Ctrl+shift+# > > or use > =TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/") > > > > > > > > > > On Fri, Nov 25, 2011 at 11:18 AM, wrote: > > All, > > > Is there a formula which converts text to date? > > > PFA the sample file w

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-25 Thread kJo
Gr8.. NOORAIN ANSARI wrote: > Dear Krishnann, > > Press Ctrl+shift+# > > or use > =TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/") > > On Fri, Nov 25, 2011 at 11:18 AM, wrote: > > > All, > > > > Is there a formula which converts text to date? > > > > PFA the sample file which I am trying to convert.. >

Re: $$Excel-Macros$$ Job

2011-11-25 Thread Bé Trần Văn
2011/11/25 ashish koul > *Recruiter: *ut...@ecsindia.co.in > > *Dear Candidate,* > > I have your old profile in my Database. Here with this mail, I would like > to inform you that at present we have opening with Top MNCs in Gurgaon (NCR > Delhi) for the position of Assistant Manager and Manager.

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-25 Thread Bé Trần Văn
2011/11/25 Anupam Konhar > can i please get a copy of the material?? > > Thanks n Regards > > Anupam > > On Fri, Nov 25, 2011 at 4:11 PM, Subhash Yadav wrote: > >> Thank u Noorain... >> >> >> On Fri, Nov 25, 2011 at 11:58 AM, jmothilal wrote: >> >>> THANKS SO MUCH >>> >>> J.MOTHILAL >>> >>> >>

Re: $$Excel-Macros$$ Adding Conditional Formatting to an existing formula

2011-11-25 Thread Susan 1
Thank you Chethan! On Wed, Nov 23, 2011 at 10:17 PM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Hi Sunnie, > > The attached file with the condition format. Hope these is what your > requirment was. > > Regards > Chethan Kumar BN > On Thu, Nov 24, 2011 at 5:18 AM, Susan 1 wrote: > >>

Re: $$Excel-Macros$$ Help required for a formula

2011-11-25 Thread Kenil Gala
Thank you seema.   Regards. --- On Fri, 11/25/11, seema mba wrote: From: seema mba Subject: Re: $$Excel-Macros$$ Help required for a formula To: excel-macros@googlegroups.com Date: Friday, November 25, 2011, 4:25 PM Hi, PFA. Query Solved.  Regards, Seema On Fri, Nov 25, 2011 at 7:02

Re: $$Excel-Macros$$ Help required for a formula

2011-11-25 Thread dguillett1
if you are saying that g3 should be between d3 and e3 then this formula does it for the CLOSE. =IF(AND(G3>=D3,G3

Re: $$Excel-Macros$$ Help required for a formula

2011-11-25 Thread seema mba
Hi, PFA. Query Solved. Regards, Seema On Fri, Nov 25, 2011 at 7:02 PM, Kenil Gala wrote: > Hi group, > > I have a small doubt for writing a formula and require for help for it. > i have mentioned my doubt as a comment in the attached file. > > > Thanks & Regards > > > -- > FORUM RULES (934+ m

$$Excel-Macros$$ Seeking Cheque Printing Excel/Access Template

2011-11-25 Thread ♥ . • : *¨¨* : • . ♥ . • : V . Kiran Kumar : • . ♥ . • : *¨¨* : • . ♥
Dear Friends I would like to request if anybody has cheque printing template I shall be thankful if you anybody can send me Regards V.Kiran Kumar -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

$$Excel-Macros$$ Help required for a formula

2011-11-25 Thread Kenil Gala
Hi group,   I have a small doubt for writing a formula and require for help for it. i have mentioned my doubt as a comment in the attached file.     Thanks & Regards   -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Plea

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-25 Thread Anupam Konhar
can i please get a copy of the material?? Thanks n Regards Anupam On Fri, Nov 25, 2011 at 4:11 PM, Subhash Yadav wrote: > Thank u Noorain... > > > On Fri, Nov 25, 2011 at 11:58 AM, jmothilal wrote: > >> THANKS SO MUCH >> >> J.MOTHILAL >> >> >> On Fri, Nov 25, 2011 at 11:46 AM, NOORAIN ANSARI

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-25 Thread Iqbal Merchant
Where in Andheri (east). Anybody near Thane.? Regards, Iqbal On Thu, Nov 24, 2011 at 2:37 PM, wrote: > ** > Andheri east > > > Sent on my BlackBerry® from Vodafone > -- > *From: *mangesh bavalekar > *Sender: *excel-macros@googlegroups.com > *Date: *Thu, 24 Nov 201

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-25 Thread Subhash Yadav
Thank u Noorain... On Fri, Nov 25, 2011 at 11:58 AM, jmothilal wrote: > THANKS SO MUCH > > J.MOTHILAL > > > On Fri, Nov 25, 2011 at 11:46 AM, NOORAIN ANSARI > wrote: > >> Dear Group, >> >> Please find attached some tips to learn Excel. >> >> - >> Thanks & regards, >> Noorain Ansari >> *http:/