$$Excel-Macros$$ Need support

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 pag

Re: $$Excel-Macros$$ Formula Problem

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 =NOT(EXP(E:RT)) in Excel? And d

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

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 PM UTC+5:30, Paul Schreiner wro

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

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 @ https://w

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

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* > - > > > > > > > > *“Do a

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

Great On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain wrote: > HTH > > On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma > wrote: > >> HI Expert,, >> >> i need a formula to find last collected Amount from client.For example >> PFA. >> >> >> >> >> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Need macro

l excel file in one 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.* >

$$Excel-Macros$$ Need macro

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 forma

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

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 wrote: > Respected Murali, > > Just try the Indian comapnies tickers in place of foreign companies or > th

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

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

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

--close price--volume. thanks & regards, 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 page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.

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

Dear Waseem, Thanks for your great support. On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi 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 wrote: >

$$Excel-Macros$$ Need a formula urgently

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$$ Split file individually -Need macro

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 wrote: > Dear Murali, > > Please see attached sheet, > Hope it will useful to you. > > Kindly change path in the

Re: $$Excel-Macros$$ Need rank formula

Dear Don guillet/Kris. Thank u so much for your reply. Don guillet i have a doubt for the same query that i want rank from month of jan'09 to apr'12.so what i have to do .Plz reply On Wed, May 2, 2012 at 8:21 PM, Kris wrote: > Hi, > > PFA. > > Kris > > -- > FORUM RULES (986+ members already BAN

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

Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI wrote: > 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 &

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

Dear legend, Wish you all the best.. On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain 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 group. > I keep sa

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

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 wrote: > > > Can any body gu

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

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 wrote: > > > Can any body guide me the formula to calculate the Age in excel w