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 koul.ash...@gmail.com wrote:
click on the series you will see the
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? And
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) !
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:
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
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 you
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 shraddha...@gmail.com javascript:
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
Hi
R u using lotus notes or outlook for sending emails
Regards
Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: shraddha malvankar shraddhamalvan...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 13 Sep 2013 10:57:37
To: excel-macros@googlegroups.com
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 required
you can write udf to concatenate the range
On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
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
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
=VLOOKUP(F3,A:E,MATCH(Total,$2:$2,0),0)
On Sat, Sep 14, 2013 at 9:58 AM, Shrinivas Shevde shrinivas...@gmail.comwrote:
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?
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
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:
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 excellearn2...@gmail.comwrote:
Another way
** **
G3 is lookup_value
** **
16 matches
Mail list logo