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 w
See if this helps.
Regards,
Bruno
2010/8/24 ҉Shine
> 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
Thanks Paul. Unfortunately the formula is too long for Excel. That's the
error
I got. But I certainly appreciate the effort because it does work when it's
shortened. I've come up with another solution using a pivot table but it makes
the file larger and more cumbersome. But, hey, it's a so
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 several
No problem.
It's not an "elegant" solution, but it works.
VBA would be better (and more fun)
Paul
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 1:26:55 PM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Paul: Thank you! Your "a" so
Can this work having about 21 SUMIF formulas in one cell?
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 10:26:55 AM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Paul: Thank you! Your "a" solution works and I'm sorry the sample was
HI
see if this helps you
regards
ashish koul
akoul.blogspot.com
2010/8/24 ҉Shine
> 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
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
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 9:00:11 AM
Subject: Re: $$Excel-Macros$$ Urgent: SUM
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 cal
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 wrote:
> hi sort your data on item basis first
>
> try this
>
>
> Sub Ma
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 TWI
Sent via BlackBerry by AT&T
-Original Message-
From: excel-macros+nore...@googlegroups.com
Sender: excel-macros@googlegroups.com
Date: Sun, 22 Aug 2010 23:39:03
To: Digest Recipients
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.co
12 matches
Mail list logo
