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 wrote:
> Hey,
>
> soemthing i would use, simple and easy, if its fits :)
>
> simply take another (any) column with the formula of Val , for example:
>
> C1
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: =
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
Fu
Hi,
I have a macro that does some kind of comp..task. Now I would like add
a piece of code that deletes certain column's before the maco creates
the final worksheet..
Ex. Delete Column B,C,M,AA etc. ( My headrs always start row 23)..
We tried this way..But cannot connect the existing code...
She
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, Vikas Chouhan wrote:
> yes
>
> On Sat, Jul 31, 2010 at 7:24 PM, kamlesh jain wrote:
>
>> Dea
Hi ,
Use 'reset print area", or unhide the hiden rows, freeze panes and try it
once .
i hope this wil help you
Ravi Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and lin
Hi Nadine,
If I am understanding you correctly, I'd use SUMPRODUCT.
If your data is in Columns A, B, C, then put this in D and copy down.
=SUMPRODUCT(--($A$2:$A$100=A2)*($B$2:$B$100=B2)*($C$2:$C$100=C2))
Any cell in Column D greater than 1 will indicat a duplicate in Columns A, B, C.
The numb
yes
On Sat, Jul 31, 2010 at 7:24 PM, kamlesh jain wrote:
> Dear Members,
>
> Is it possible to open a password protected excel file if password lost.
>
> Thanks in advance.
>
> --
> Regards,
> Kamlesh Jain
>
> --
>
> ---
Thanks for the response. Unfortunately vlookup makes the file too large. But
thanks so much for your suggestion. I appreciate the response.
From: "Kishan Reddy, K"
To: MS EXCEL AND VBA MACROS
Sent: Fri, July 30, 2010 10:40:48 PM
Subject: $$Excel-Macros$$ R
Dear Members,
Is it possible to open a password protected excel file if password lost.
Thanks in advance.
--
Regards,
Kamlesh Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips trick
if u try to uncheck zero values from tools option zero value
On Sat, Jul 31, 2010 at 2:02 PM, zp18 wrote:
> I have a bunch of cells that may or may not have numbers in them.
>
> Kind of like this: Sum(e35:e44) , but with no number in e44, I get the
> #Value error. What should be in a "empty" cel
Hi,
When I use SUM on a range of cells that may or may not be numeric, I don't get
a value error. Blank cells seem to be treated as zeros, and text cells are
ignored. I use xl2003. But perhaps I'm not understanding correctly. Could you
attach a sample workbook?
Regards - Dave
> Date: Sat, 3
Hi Pooja
Can you send that excel file, so that our excel experts in the group
can resolve your query.
Rajender Soni
On Jul 30, 2:01 pm, Pooja S wrote:
> 2003 h/..but jo apne bataya vo already tha ..but fir b macros nai h
>
>
>
>
>
> On Fri, Jul 30, 2010 at 2:16 PM, Aindril De wrote:
> > Which
How it is possible send me the procedure
Regards,
Muhammad Ahmed
Pakistan
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Nandkumar kakvipure
Sent: Saturday, July 31, 2010 9:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
I have a bunch of cells that may or may not have numbers in them.
Kind of like this: Sum(e35:e44) , but with no number in e44, I get the
#Value error. What should be in a "empty" cell that would allow excel
to treat it as zero but not have a bunch of zeroes all over the
worksheet? Isnumber() wo
Dear Group,
In the recent group survey conducted, I asked one question that "How
the top posters should be rewarded in the group "... and most of you
replied that we should announce the name of top poster every month...
So the time has come to announce the Top Poster of July 2010 and i.e.
Our ow
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, for your help.
>
> But kindly tell me if i save macro in This Workbook,
>
> Will it work for other workbooks.
>
> REHAN
>
> O
YES
On Sat, Jul 31, 2010 at 1:28 AM, shashank bhosle <
catchshashankbho...@yahoo.co.in> wrote:
>Hi,
> Is it possible to crack the password for the excel window.
>
>
> --
>
> --
> Some important links for excel u
Nadine,
This can be done using Vlookup function and filter command.
Use Vlookup function on Column B, and another Vlooku on Column C
Then Use filter command on Vlookuped columns where there are no #NA
values.
Great things can be done with available (inbuilt) functions and
commands in excel, pro
ya its posible
On Sat, Jul 31, 2010 at 1:28 AM, shashank bhosle <
catchshashankbho...@yahoo.co.in> wrote:
> Hi,
> Is it possible to crack the password for the excel window.
>
>
> --
>
> --
20 matches
Mail list logo
