RE: $$Excel-Macros$$ SumProduct

Ur welcome Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, September 16, 2013 12:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SumProduct Hello, Thanks its w

Re: $$Excel-Macros$$ SumProduct

Hello, Thanks its working fine.. On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar wrote: > Hi, > > ** ** > > Try this.. > > ** ** > > =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) > > ** ** > > ** ** > > * * > > *Warm Regards,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-

Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation

U're welcome i' stay in Borneo Island (Indonesia) (^_^) Pada 16/09/2013 13:13, Vishwanath menulis: Dear De Premor, I have no words to say thanks.. You are really great. Which place you from? Wish i could meet you some time. rgds vishwanath On 13 September 2013 08:39, De Premor

Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation

Dear De Premor, I have no words to say thanks.. You are really great. Which place you from? Wish i could meet you some time. rgds vishwanath On 13 September 2013 08:39, De Premor wrote: > PFA and try to run macro named SAVE on module1 > > > On 29-08-2013 18:57, Vishwanath wrote: > > Dear Ex

Re: $$Excel-Macros$$ Query on vlookup

Dear Shrinivas, u can also use =VLOOKUP(F3,A3:E13,COLUMNS(A3:E3),0) Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Sat, Sep 14, 2013 at 11:07 AM, Shrinivas Shevde wrote: > Dear Ashish,De Premor,Ravi Kumar > > Very very tha

Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Thanks ITWare for replying. Your answer works too. -- 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. Poor thr