Please follow the link.
http://www.ozgrid.com/VBA/ExtractNum.htm
Hope it serve the purpose.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, August 23, 2010 5:23 PM
To:
Sent via BlackBerry by ATT
-Original Message-
From: excel-macros+nore...@googlegroups.com
Sender: excel-macros@googlegroups.com
Date: Sun, 22 Aug 2010 23:39:03
To: Digest Recipientsexcel-macros+dig...@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Hi,
I want to login to facebook.com using XmlHtpp Object. How can i do
so??If not do any one has examples to login to any other websites???
Thanks
--
--
Some important links for excel users:
1. Follow us on
Thank you Ashish. I appreciate your effort and time you spent for it. But I
am looking for a combination function that can do the job. VBA cannot be
used
Thank you
Best Regards
Shine
On 23 August 2010 20:52, ashish koul koul.ash...@gmail.com wrote:
hi sort your data on item basis first
Well... I've got A solution:
=SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P)
+SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U)
+SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z)
...
btw: your sample result is incorrect.
rows 6 and 7 are 167891
instead of 567891,
yet you included them in your
Paul: Thank you! Your a solution works and I'm sorry the sample was wrong.
I can't thank you enough for your assistance.
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 9:00:11 AM
Subject: Re:
HI
see if this helps you
regards
ashish koul
akoul.blogspot.com
2010/8/24 ҉Shine shin...@gmail.com
Thank you Ashish. I appreciate your effort and time you spent for it. But
I am looking for a combination function that can do the job. VBA cannot be
used
Thank you
Best Regards
Shine
No problem.
It's not an elegant solution, but it works.
VBA would be better (and more fun)
Paul
From: None n8dine4ma...@yahoo.com
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 1:26:55 PM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Paul:
it might be a problem with the length of the function!
depending your your version of Excel, it MAY have a 256 character limit.
Each sumif statement is nearly than 50 characters,
so 21 of them would be 1050 characters!...
you may have a problem... it may mean you need to separate it into
Hi Team Members,
I have a query with regard to outlook email. Can anyone please suggest or
advice me how to proceed with this.
Requirement: An email should be send automatically with below subject and
body to the mentioned address. Copying the left most sheet in the attached
excel in a separate
10 matches
Mail list logo