Hi,
Try these below mentioned formulas
=SUMPRODUCT(((--(A1:A4={a,b})*B1:B4)) / (COUNTIF(A1:A4, a) +
COUNTIF(A1:A4, b)))
OR
=SUMPRODUCT((--(A1:A4={a,b})*B1:B4))/SUMPRODUCT(--(A1:A4={a,b}))
Hope this is what you want.
Regards,
Swapnil.
On Fri, Jan 31, 2014 at 8:04 PM, Chandra Shekar
Those who are using BBM Channel check out this channel. Channel Pin C002AB8CF.
:)
Thanks Regards,
Sandeep Kumar Chhajer
Mumbai
India
Sent on my BlackBerry(R) from Vodafone
--
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
Hi Team,
Any luck of my earlier mail.
Regards
Atul
On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi
PFA fileplease note that the attachment which need to go with each
mail would be a PDF file.
On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria
http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.html
http://support.microsoft.com/kb/213360
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
check above links
On Thu, Jan 30, 2014 at 2:39 PM, Harish P Y py.har...@gmail.com wrote:
Dear Excel
can you share sample file
On Tue, Jan 28, 2014 at 1:41 PM, Camukesh2015 camukesh2...@gmail.comwrote:
Hi EverReady,
I have downloaded a macro code for spell numbers in Indian Rupees, in
Lakhs and Crore notation. But I am facing a problem in the code. Code is
working fine upto 200 crore
Pls provide some example mails with respective attachments which you wants to
merge.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of BUNTY
Sent: Saturday, February 01, 2014 10:16 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ - Download
can u please share the workbook
On Mon, Jan 27, 2014 at 9:18 PM, excelfor...@gmail.com wrote:
Please merge the below given both the codes so that i can use it in one
module.
1. to insert current date and time in A column when data entered in B
column.
Private Sub Worksheet_Change(ByVal
Sub test()
Dim mailrng As Range
Dim cl As Range
Dim fl_path As String
Set mailrng = Sheets(Sheet1).Range(c2:c5)
For Each cl In mailrng
Call sendmail(cl.Value, cl.Offset(0, -1).Value, cl.Offset(0, 1))
Next
End Sub
Sub sendmail(mailid As String, nm As String, flname As String)
Dim OutApp
Sub test()
Sheets(Output).UsedRange.Clear
Dim i As Long
Dim j As Long
Dim k As Long
Dim s As Long
k = 2
Sheets(Input).Select
For i = 2 To Range(a4).Row
For j = Range(e5).Column To Range(g5).Column
For s = Range(i5).Column To Range(k5).Column
Range(a i :c i).Copy
Hello,
First you need to create an outlook mail object, then, write the mail body
(in html) with the appropriate img src='myfile.jpg' tag. Please note
following points :
- embedded images must be save on your computer (as a jpg file or png file)
;
- Since outlook 2013, embedded images must
Hi Ashish,
You are rockstar. Just one last help. Can the range be set a dynamic rather
than staticas the range will vary from time to time.
Regards
Atul
On Sun, Feb 2, 2014 at 9:50 PM, ashish koul koul.ash...@gmail.com wrote:
Sub test()
Dim mailrng As Range
Dim cl As Range
Dim
try this
Set Mailrng = Sheets(Sheet1).Range(c2:c
Sheets(Sheet1).Range(c1).End(xlDown).Row)
On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi Ashish,
You are rockstar. Just one last help. Can the range be set a dynamic
rather than staticas the range will
This is very useful.
http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.htmlhttp://support.microsoft.com/kb/213360
Thanks for this Link.
--
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
Thanks Ashishreally helpfull...
On Mon, Feb 3, 2014 at 10:50 AM, ashish koul koul.ash...@gmail.com wrote:
try this
Set Mailrng = Sheets(Sheet1).Range(c2:c
Sheets(Sheet1).Range(c1).End(xlDown).Row)
On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi
14 matches
Mail list logo