$$Excel-Macros$$ Need support

2016-11-30 Thread Murali Nagarajan
Dear team, Below mentioned formula is not working properly.how to use the formula =VLOOKUPNTH($E2,$A$2:$C$209,3,10) *Note: File has been attached* *regards* *N.Murali* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook

Re: $$Excel-Macros$$ Formula Problem

2016-08-12 Thread Murali Nagarajan
Dear Sourav, I hope you are doing great. Regards N.Murali On Thu, Aug 11, 2016 at 6:41 PM, sourav devrani wrote: > Hey guys, > I need your help. > Please see the attached file. > Regards > Sourav Devrani > > -- > Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-20 Thread Murali Nagarajan
Dear Sachin, PFA On Tue, Jul 19, 2016 at 4:59 PM, सचिन शर्मा wrote: > Thanks Paul, > > For answer and your observation, > > Now it's working correctly. > > Regards. > > *Sachin* > > # +91 97 16 437516 > # +91 72 91 932360 > > On Tuesday, July 19, 2016 at 4:51:00

$$Excel-Macros$$ Multiple Mail merge same page

2016-02-10 Thread Murali Nagarajan
Dear All, Please help me that how to make multiple mail merge same page . I have more than 200 customers details ( Ma,e,Address,contact no,) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Break the file Password

2015-09-23 Thread Murali Nagarajan
Hi, If it's Excel file please attached the same. On Tue, Sep 22, 2015 at 5:33 PM, Paul Schreiner wrote: > Please not Forum rules #3: > > 3) Don't post questions regarding breaking or bypassing any security > measure > > > *Paul* >

Re: $$Excel-Macros$$ need Excel formula

2015-08-27 Thread Murali Nagarajan
Great On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain abhishek@gmail.com wrote: HTH On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com wrote: HI Expert,, i need a formula to find last collected Amount from client.For example PFA. -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Need macro

2014-09-15 Thread Murali Nagarajan
Dear All,I need your valuable help which will be reduce my time to compile data without any errorRequirementMonth on month I received huge data base from my Head office to compile and send the same to Respective managerAll Sheets data

Re: $$Excel-Macros$$ Need macro

2014-09-15 Thread Murali Nagarajan
folder macro will port data one by one from all sheets all workbook. Do let us know if any error.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 4:11 PM, Murali Nagarajan muralin...@gmail.com javascript:_e(%7B%7D,'cvml

$$Excel-Macros$$ grouping data of range boundaries...

2013-09-19 Thread Murali prasad
Hi Experts Hope you all doing good... i need help on summing the data for the grouped range boundaries file attached for the easy reference... thanking you... murali.. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

Re: $$Excel-Macros$$ Stock prices data fetching through VBA

2013-09-19 Thread Murali
Respected vijay, Thank you very much for the support, i have tried with indian codes only, unfortunately its not working... On Thu, Sep 19, 2013 at 1:22 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Murali, Just try the Indian comapnies tickers in place of foreign companies

$$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread MURALI NAGARAJAN
Dear All, I have a data base like colum A contains State name colum B contains city name against state name, im going to create a report that city name will be displayed in accordance with the change in the state name . Note:Sample data attached along with this mail. Do the needful. Thanks

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread MURALI NAGARAJAN
Dear Waseem, Thanks for your great support. On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi waseemsa...@gmail.com wrote: Dear Murali, Please see in attachment. it might be helpful. Regards, Waseem Saifi On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear

Re: $$Excel-Macros$$ Split file individually -Need macro

2012-05-03 Thread MURALI NAGARAJAN
Dear noorain. Thank for your reply.but i can't able to open that file.plz sent that fils in excel format. On Thu, May 3, 2012 at 3:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Murali, Please see attached sheet, Hope it will useful to you. Kindly change path in the code

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

2011-10-24 Thread MURALI NAGARAJAN
Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3

Re: $$Excel-Macros$$ Thanks everyone.

2011-10-04 Thread MURALI NAGARAJAN
Dear legend, Wish you all the best.. On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am proud to share that I have been re-awarded the Micrososft MVP award in 2011. My deep thanks to each group member for all your support and contribution to this

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread MURALI NAGARAJAN
Dear varun, You can use below mentioned formulas.. =DATEDIF(C8,TODAY(),y) =For Year =DATEDIF(C8,TODAY(),ym) =For Month =DATEDIF(C8,TODAY(),md) =For Days On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote: Can any body guide me the formula to calculate

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread MURALI NAGARAJAN
Dear varun, There is one more formula available. =Age is DATEDIF(C8,TODAY(),y) Years, DATEDIF(C8,TODAY(),ym) Months and DATEDIF(C8,TODAY(),md) Days For Example:Age is 51 Years, 8 Months and 7 Days On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote: Can any body