I like Dave's answer. It seems to work the best. Thanks.
On Sun, Aug 1, 2010 at 1:28 AM, Dave Bonallack wrote:
> Hi,
> Try changing the formula in M3 to:
>
> IF(COUNT(M1,M2)>0,*SUM(M1:M2)*,"")
>
> I think *M1+M2* is the problem. The '+' operand can't seem to handle
> non-numeric inputs, wherea
Hi Angelo,
The summing could be done with worksheet functions - probably SUMPRODUCT. But
the deleting of lines has to be done by macro, so it makes sense to do both by
macro. I can't look at it straight away, but if no one else comes up with
anything, I'll have a look later.
Regards - Dave.
I have a workbook that needs a sumproduct.
I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))
What I need is a total of the result of that plus th
Hello!
I'm working on a thing where I will be running a loop to caluclate
results based on a G and E variables. The ultimate goal is to get to a
thing that has all of the results in a table, where I have a value for
G1*E1, G1*E2, G2*E1, G2*E2 (Think of a big old multiplication table).
So the macr
hi all,
i am preparin a macro in which i need to extract the data from pdf file and
then make necessary changes accordin to the requirement.
can you please help me out as to how i should extract the data from pdf
through vba.
thanks in advance
saber
--
Dave,
Thank you so much. This works! You don't know how thankful I am. I needed
that peice before I could move forward with a workbook. Thank you!!!
Nadine
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Sun, August 1, 2010 10:23:44 PM
Su
Sid,
How do i use this in the existing code?As how to call it etc tec
Skanda.
On Mon, Aug 2, 2010 at 5:27 AM, Sid. wrote:
> Hi Skanda,
>
> It probably looks something like this (you may have to tweak the Row/
> Column values depending on the overall structure of your worksheet)
>
> Sub Select_C
hi all,
can anybody help me out in sovin the below problem.
-- Forwarded message --
From: mohd ateeq
Date: Thu, Jul 29, 2010 at 9:25 PM
Subject: Re: $$Excel-Macros$$ Re: automation error
To: excel-macros@googlegroups.com
Thanks a lot stuart...
Actually i have a excel file
Forgot the attachment, sorry :)
2010/8/2 Angelo Spinola
> Hello All,
>
> I need a formula that
> Checks if B,C, D are the sameif equal (could have more than just two
> equal) sums the Columns E and F and replace it for just one Line instead of
> having duplicates or triplicates.
>
> How can
Hello All,
I need a formula that
Checks if B,C, D are the sameif equal (could have more than just two
equal) sums the Columns E and F and replace it for just one Line instead of
having duplicates or triplicates.
How can i create this ? With a Macro ?
Regards.
--
---
Dear Team members,
I have joined the below google group which is very useful for us.
As a member in coreteam, we mostly use excel.
This group is very useful to learn advanced features of excel.
*excel-mac...@googlegroups.com.*
If you have any problem in excel, you can join and post in this grou
Looks like a part of the content in the file is corrupt..and cannot be
repaired
Regards,
Andy
On Mon, Aug 2, 2010 at 3:56 PM, Deepak Rawat wrote:
> Hi all
>
> This is a excel file and its not opening normally can anybody fix the
> problem.
>
> Regards,
> Deepak
>
> --
>
> ---
Hi Skanda,
It probably looks something like this (you may have to tweak the Row/
Column values depending on the overall structure of your worksheet)
Sub Select_Char7to25()
'
'
Application.Goto Reference:="R6C2"
Range("B6").Select
ActiveCell.FormulaR1C1 = "=MID(RC[-1],7,19)"
Applic
Hi Skanda,
Using worksheet funtions, it would just be:
=MID(B6,7,19) copied down.
Programatically it would include a For/Next loop, but the otherwise look very
similar:
Sub SevenToTwentyfive()
For i = 6 To 1000
Cells(i, 3) = Mid(Cells(i, 2), 7, 19)
Next i
End Sub
This w
Thanx
REHAN
On Sat, Jul 31, 2010 at 11:54 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Just open the workbook in which you have created the macro.
>
> It will work in generally.
>
> Regards,
> Kishan Reddy, K
>
> On Jul 30, 2:32 pm, Rehan Baig wrote:
> > Kishan
> >
> > Thanx
Santiago Afonso wrote:
> Hello. I'd like to use the equation editor in excel 2010 through VBA. In
> Word, the equation object is OMath (
> http://msdn.microsoft.com/en-us/library/bb256563%28office.12%29.aspx), and
> the macro recorder records some actions done to such an object (like
> changing equ
David,
Thanks so much for your efforts. I'll start with this and see if I can come up
with something. I do however need to change the vlookup to an index,match due
to the size the vlookup will make the file. Index,match makes the file size
smaller, at least from what I've found in using both
17 matches
Mail list logo
