Hey,
soemthing i would use, simple and easy, if its fits :)
simply take another (any) column with the formula of Val , for example:
C1D1
10 =val(C1)
=val(C2)
and so on.
and simply take the sum of Column D.
hope it helps.
Best regards,
M. Shujaat Ali
OK, here is an example: The whole idea is to prevent a data entry
spreadsheet having a bunch of zeroes in all the totalizing columns. Cells
K1,L1 and K2,L2 have been Clear Contents, Cell M3 the totalizer cell is
blank. Put a 1 in K1 and the #Value error appears in M3
Cell M1:
Woopss...
Sorry for in-complete formula:
keep the formula as =if(C1=,0,C1)
regards,
On Sun, Aug 1, 2010 at 8:39 AM, Shujaat Ali shujaa...@gmail.com wrote:
Hey,
soemthing i would use, simple and easy, if its fits :)
simply take another (any) column with the formula of Val , for
how is it possible to doi this ? :) Regards
2010/8/1 N.Shivkumar shiv1...@gmail.com
Dear Kamlesh Jain
Is it possible to send me the file I will find the passwod
BYe
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
On 31 July 2010 21:08,
I forgot to say that the drop-down is in C1
Regards - Dave.
Date: Sun, 1 Aug 2010 01:36:25 -0700
Subject: $$Excel-Macros$$ Question re: cell comments and validated lists
From: simon_mc_webs...@yahoo.co.uk
To: excel-macros@googlegroups.com
Good Evening Gurus,
I have a quick question
hi friend,
i attached an excel file, which having some information in it, now i want
that if i will do any type of change in it, i will be able to trace it,
means, i change in some of the column or row, or i introduce any new row ,or
delete any row. every type of change i want to trace.,
plz
Any progress on the file formating?
*Joel*
On Sun, Jul 25, 2010 at 03:35, Sandeep Kumar Maurya
sandymau...@gmail.comwrote:
Hi,
I got your file but next time use gmail and attach in the mail.
Thanks Regards
Sandeep
On Sun, Jul 25, 2010 at 1:02 AM, JD 5635.daw...@gmail.com wrote:
How
I have information in the first three cells of a worksheet and in the forth is
a
Yes or No.
In worksheet 2 the first three columns contain the same type of information as
in sheet1 but sheet 1 can list that information multiple times whereas sheet 2
only lists that unique combination once.
Resending with a subject. Sorry.
I have information in the first three cells of a worksheet and in the forth is
a
Yes or No.
In worksheet 2 the first three columns contain the same type of information as
in sheet1 but sheet 1 can list that information
That's it exactly! Many thanks Dave,
Sid.
On 1 Aug, 13:32, Dave Bonallack davebonall...@hotmail.com wrote:
I forgot to say that the drop-down is in C1
Regards - Dave.
Date: Sun, 1 Aug 2010 01:36:25 -0700
Subject: $$Excel-Macros$$ Question re: cell comments and validated lists
From:
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 equations from professional to
You're welcome
Dave.
Date: Sun, 1 Aug 2010 10:24:21 -0700
Subject: Re: $$Excel-Macros$$ Question re: cell comments and validated lists
From: simon_mc_webs...@yahoo.co.uk
To: excel-macros@googlegroups.com
That's it exactly! Many thanks Dave,
Sid.
On 1 Aug, 13:32, Dave Bonallack
Hi,
This is close, but not quite there. The lookup is in cell A1, and
there are two tables, B2 thru C15 and D2 thru E15. The Formula is in
cell A2. It still needs some work, but I think the concept is there.
15
T1 1 1 15 15
2 2 16 16
3
Hi Nadine,
Have a look at the attached.
It's a bit long-winded, but seems to work ok.
Regards - Dave.
Date: Sun, 1 Aug 2010 08:23:35 -0700
From: n8dine4ma...@yahoo.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I have information in the first three cells of a
14 matches
Mail list logo