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

2013-09-13 Thread Shrinivas Shevde
Dear Ashish,De Premor,Ravi Kumar Very very thanks for the help All are working fine Thanks once again regards Shrinivas On Sat, Sep 14, 2013 at 10:36 AM, Ravi Kumar wrote: > Another way > > ** ** > > G3 is lookup_value > > ** ** > > =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH("total",A2:F2,

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

2013-09-13 Thread Ravi Kumar
Another way G3 is lookup_value =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH("total",A2:F2,0)-1) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of De Premor Sent: Saturday, September 14, 2013 10:03 AM To: excel-macros@go

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

2013-09-13 Thread De Premor
Try this formula *=VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0)* On 14-09-2013 11:28, Shrinivas Shevde wrote: Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

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

2013-09-13 Thread ashish koul
=VLOOKUP(F3,A:E,MATCH("Total",$2:$2,0),0) On Sat, Sep 14, 2013 at 9:58 AM, Shrinivas Shevde wrote: > Dear All > Query on vlookup > Please look at the attached sheet. > > Thanks in advance > > -- > Shrini > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME

$$Excel-Macros$$ Query on vlookup

2013-09-13 Thread Shrinivas Shevde
Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- 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 c

Re: $$Excel-Macros$$ Concatenate.

2013-09-13 Thread ashish koul
you can write udf to concatenate the range On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav wrote: > Dear All, > > Can we concatenate by using range with Arrey formula.? > > for example > > From Range("A2:K2") ..i have to concatenate.. but for this i have to put > formula > like concatenate

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread ashish koul
try this see if it works Sub send_venddetails() Dim i As Long Dim flname As String Dim objOL As Object Dim wkb As Workbook Set objOL = CreateObject("Outlook.Application") For i = 2 To Sheets("data").Range("a65356").End(xlUp).Row With Sheets("Verification") 'clear exisitng if requir

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread koul . ashish
Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: shraddha malvankar Sender: excel-macros@googlegroups.com Date: Fri, 13 Sep 2013 10:57:37 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Ma

$$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread shraddha malvankar
Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to Ve

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread shraddha malvankar
Outlook. Regards, Shraddha On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote: > > Hi > > R u using lotus notes or outlook for sending emails > > Regards > Ashish > Sent on my BlackBerry® from Vodafone > -- > *From: * shraddha malvankar > > *Sender: * excel-..

$$Excel-Macros$$ Concatenate.

2013-09-13 Thread Prafull Jadhav
Dear All, Can we concatenate by using range with Arrey formula.? for example >From Range("A2:K2") ..i have to concatenate.. but for this i have to put formula like concatenate(A2,B2,C2,D2...) Can we do this by using Range. concatenate(Range("A2:K2") Regards, Prafull Jadhav. -- Are yo

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

2013-09-13 Thread Vandalo
Hi Chih Hung, You will need three files to achieve the goal you pretend. File 1 - Origem. This will be the file you got every 2 week with your source data. File 2 - Modelo. This is the file where you will paste data from file Origem. File 2 - Controlador. This is the file where resides the vba co

RE: $$Excel-Macros$$ SumProduct

2013-09-13 Thread Ravi Kumar
Hi, Try this.. =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Friday, September 13, 2013 4:21 PM To: excel-macros@googlegroups.c

$$Excel-Macros$$ SumProduct

2013-09-13 Thread Chandra Shekar
Hi, I have a problem with Sumproduct function please find attached file for the same where from E1, F1 & G1 are condtions based on it I need sum up Column D. Thanks in advance. Regards, Chandra -- 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) !

Re: $$Excel-Macros$$ Update Database From Another Sheet

2013-09-13 Thread Hilary Lomotey
Simple Genius Excellent Work my friend, its absolutely beautiful. very very grateful thanks On Fri, Sep 13, 2013 at 11:08 AM, Ravinder wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (ravinderexcelgr...@gmail.com) Add cleanup > rule<

$$Excel-Macros$$ Re: 2 LOOKUP-2 MATCH FUNCTION

2013-09-13 Thread Nemi Gandhi
Thank you very much Ravinderji... Nemi Gandhi On Thursday, September 12, 2013 1:36:05 PM UTC+5:30, Nemi Gandhi wrote: > > Attached worksheet for Nakshatra match gunank function. please give me > formula. > > -- > Nemi Gandhi > 98204 92963 > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Dynamic Chart

2013-09-13 Thread Chandra Shekar
Hello Ashish, I got the solution for this and also attached formulas if somebody can use it. Let me know is there any steps for doing it Thank you very much. Regards, Chandra On Thu, Sep 12, 2013 at 7:06 PM, ashish koul wrote: > click on the series you will see the formula like below > > =S