Dear Harish,
Please find attachment of addin.
Please use reply.
Thanking you
(it was received by me in 2009 through this group)
On 30 January 2014 14:39, Harish P Y py.har...@gmail.com wrote:
Dear Excel Gurus,
Please find the attached file Marks Sheet,
and i want to obtain the marks
Hi,
Please help,
How to convert number to Indian rupees with caps letters in excel formula...
regards
Kannan V
--
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
please take reference from below link and use upper case function
http://foreignpostmumbai.blogspot.in/2011/11/convert-rupees-in-figure-to-rupees-in.html
.
Enjoy
Team XLS
On Mon, Feb 3, 2014 at 2:38 PM, Kannan Excel kannan.ex...@gmail.com wrote:
Hi,
Please help,
Thanks its working fine :)
On Sun, Feb 2, 2014 at 1:33 PM, Swapnil Palande palande.swapni...@gmail.com
wrote:
Hi,
Try these below mentioned formulas
=SUMPRODUCT(((--(A1:A4={a,b})*B1:B4)) / (COUNTIF(A1:A4, a) +
COUNTIF(A1:A4, b)))
OR
Hi Ashish,
Thanks a lot for the code, it worked well. It saved lot of my time.
One question, do you know how to add a condition that if the % is given as
zero, then we can ignore that particular cell.
I have given an example in my initial question.
The reason I am requesting for including this
It is not working Sir
With Regards
*HARISH P Y*
*P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it
is really necessary. Thanks for your support to protect our environment for
the future generation*
*1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere 3
Dear,
use this. =num2text(reference)
Please check attachment.
thanking you
On 4 February 2014 09:42, Harish P Y py.har...@gmail.com wrote:
It is not working Sir
With Regards
*HARISH P Y*
*P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether
it is really necessary.
Dear Experts,
Can anyone help on my query.
I have to activate and other applications like Internet explorer, SAP
etc.., through writing macro.
Is this possible?
/Suresh
--
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
You can use shell command in vba
Sub openotherapp()
Shell C:\Program Files\Internet Explorer\iexplore.exe, vbNormalFocus
'path of exe file of IE, u can use same for SAP (put exe filepath)
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
Hi,
Waw.. Its working.. but its only opening, not able to click on File,
Edit etc..,
On Tue, Feb 4, 2014 at 11:02 AM, Ravinder ravindervbacli...@gmail.comwrote:
You can use shell command in vba
Sub openotherapp()
Shell *C:\Program Files\Internet Explorer\iexplore.exe*,
Please advise what u want exactly
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of suresh k
Sent: Tuesday, February 04, 2014 11:10 AM
To: Excel group
Subject: Re: $$Excel-Macros$$ Access other applications using macro's
Hi,
Waw.. Its working..
Hi,
I need macro for the following cases.
Case 1: I have the list of document numbers in excel where I will paste
those in SAP application. Now I am picking this data manually everyday. If
I enter one document number in SAP I am getting the data for it, in same
way I have to download data for
TEST
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of BUNTY
Sent: Sunday, February 02, 2014 11:46 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ - Download attachments and merge spreadsheets
Dear Gurus,
I need serious help from you
Hi All, I am Nitin Mittal, working as HR Manager in Stonehill International
School Bangalore. I want to learn advanced Excel and VBA, hence joined here.
--
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
14 matches
Mail list logo